Integrated Terminal in SQL Operations Studio (Preview)

This guide covers integrated terminal in SQL operations studio (preview) with practical context and easy-to-follow details. Use it to understand the subject and apply the information confidently.

To open the terminal:

Use keyboard shortcut Ctrl + ` .
Use the View | Command Integrated Terminal menu .
From the Command Palette (Ctrl + Shift + P) , use the View Command : Toggle Integrated Terminal.

Note : You can still open an external shell with Explorer Open in Command Prompt (open in Terminal on Mac or Linux), if you prefer to work outside of SQL Operations Studio (preview).

You can create multiple terminals in different locations and easily navigate between them. You can add terminals by clicking the plus icon at the top right of the TERMINAL Control panel or by activating the Ctrl + Shift + ` Command. This creates another entry in the list, which can be used to switch between terminals.

Tip: If you use multiple terminals, you can add the main constraints for FocusNext, focusPrevious And Kill Commands listed in the " Binding keys in the terminal " section below, to allow navigation between the terminals with only keyboard.

Properly configure your shell on Windows including locating the appropriate executable file and updating the settings. Below is a list of common shell executables and their default locations:

 // 64-bit cmd if available, otherwise 32-bit 
 "terminal.integrated.shell.windows": "C: Windowssysnativecmd.exe" 
 // 64-bit PowerShell if available, otherwise 32-bit 
 "terminal.integrated.shell.windows": "C: WindowssysnativeWindowsPowerShellv1.0powershell.exe" 
 // Git Bash 
 "terminal.integrated.shell.windows": "C: Program FilesGitbinbash.exe" 
 // Bash on Ubuntu (on Windows) 
 "terminal.integrated.shell.windows": "C: Windowssysnativebash.exe"

Note : To be used as an integrated terminal, the executable shell must be a console app so Stdin / stdout / stderr Can be redirected.

Tip : Shell integrated terminal is running with the rights of SQL Operations Studio (preview). If you need to run shell commands with advanced admin rights or different permissions, you can use platform utilities like Runas. Exe In a terminal.

You can pass arguments to the shell when it is started.

For example, to allow bash to run as a login shell (run . Bash_profile), Switch in the -l Argument (with quotation marks):

 // Linux 
 "terminal.integrated.shellArgs.linux": ["-l"]

You can customize the font and line height for the integrated terminal with the following settings:

```
 terminal.integrated.fontFamily 
```
```
 terminal.integrated.fontSize 
```
```
 terminal.integrated.lineHeight 
```

View Command : Toggle Integrated Terminal Is linked with Ctrl + ` To quickly switch the terminal control panel built-in and out of sight.

Here are the shortcuts for quick navigation in the integrated terminal:

CommandKey combination Ctrl + `Integrated terminal display Ctrl + Shift +` Create new terminal Ctrl + Up Scroll up Ctrl + Down Scroll down Ctrl + PageUp Scroll page Ctrl + PageDown Scroll down page Ctrl + Home Scroll to the top of the page Ctrl + End Scroll to the bottom of the page Ctrl + K Delete the terminal

Other terminal commands are available and can be assigned with your favorite shortcuts, including:

Workbench. Action. Terminal. Focus: Focus on the terminal. This is like a conversion but focuses on the terminal instead of hiding them, if the user can see them.
Workbench. Action. Terminal. FocusNext: Focus on the next terminal instance.
Workbench. Action. Terminal. FocusPrevious: Focus the previous instance instance.
Workbench. Action. Terminal. Kill: Remove the current terminal instance.
Workbench. Action. Terminal. RunSelectedText: Run the selected text in the terminal.
Workbench. Action. Terminal. RunActiveFile: Run the active file in the terminal.

If no text is selected in the active editor, the line that the cursor is set to is run in the terminal.

Assigning keys to copy and paste conform to platform standards:

Linux: Ctrl + Shift + C And Ctrl + Shift + V
Mac: Command Prompt + C And Command Prompt + V
Windows: Ctrl + C And Ctrl + V

The integrated terminal has a basic search function that can be activated with Ctrl + F.

If you want Ctrl + F to Open the shell, instead of launching the search utility on Linux and Windows, you need to delete the key link as follows:

 {"key": "ctrl + f", "command": "-workbench.action.terminal.focusFindWidget", 
 "when": "terminalFocus"},

While the focus is on the integrated terminal, many of the key keys assigned will not work, because key combinations are transmitted and are suppressed by the terminal itself. Terminal. Integrated. CommandsToSkipShell setting can be used to do this. It contains an array of command names with assigned keys, bypassing shell processing and instead is handled by the system binding SQL Operations Studio (preview) keys. By default, this includes all the keys assigned in the terminal, adding some commonly used key options.