Use the following shortcut keys when working with an SQL document or stored procedure.
Command Name | Shortcut Keys | Action | Where is used |
---|---|---|---|
Execute | F5 | Execute query associated with current document | SQL Editor, Query Builder |
Execute Current Statement | F8 | Execute current statement | SQL Editor |
Previous SQL | Ctrl+Shift+Up Arrow | Previous SQL statement from history | SQL editor |
Next SQL | Ctrl+Shift+Down Arrow | Next SQL statement from history | SQL editor |
SQL History | Ctrl+Alt+H | Open SQL History dialog | SQL editor |
Edit Parameters | Ctrl+Shift+P | Edit parameters | SQL editor |
Redirect Data To Output Window | Ctrl+Shift+T | Show data as text in the Output window | SQL editor |
List Members | CTRL+J | List members | SQL Editor |
List Members | CTRL+K, L | List members | SQL Editor |
Complete Word | CTRL+SPACE | Complete word | SQL Editor |
Complete Word | CTRL+K, W | Complete word | SQL Editor |
Complete Word | ALT+Right Arrow | Complete word | SQL Editor |
Parameter Info | CTRL+SHIFT+SPACE | Parameter information | SQL Editor |
Parameter Info | CTRL+K, P | Parameter information | SQL Editor |
Insert Template | CTRL+K, X | Insert code template | SQL Editor |
Insert Template | CTRL+K, CTRL+X | Insert code template | SQL Editor |
Quick Info | CTRL+K, I | Display quick information | SQL Editor |
Quick Info | CTRL+K, CTRL+I | Display quick information | SQL Editor |
Comment Selection | CTRL+E, C | Comment Selection | SQL Editor |
Uncomment Selection | CTRL+E, U | Uncomment selection | SQL Editor |
Toggle Outlining Expansion | CTRL+M, M | Toggle outlining expansion | SQL Editor |
Toggle All Outlining | CTRL+M, L | Toggle all outlining | SQL Editor |
Stop Outlining | CTRL+M, P | Stop outlining | SQL Editor |
CTRL+F2 | Switch to Navigation Bar | SQL Editor | |
CTRL+ALT+PGUP | Switch from the current document tab to the previous tab | SQL Editor | |
CTRL+ALT+PGDOWN | Switch from the current document tab to the next tab | SQL Editor | |
CTRL+PLUS SIGN (+) KEY | Zoom font size in | SQL Editor | |
CTRL+MINUS SIGN (-) KEY | Zoom font size out | SQL Editor | |
CTRL+0 | Reset font size to the default value | SQL Editor | |
Go To Definition | F12 | Go to definition | SQL Editor |
CTRL+R | Hide/Show additional document views | SQL Editor | |
Analyze Code | CTRL+K,A | Runs T-SQL Analyzer | SQL Editor |
CTRL+L | Delete current code line and copy it to clipboard | SQL Editor | |
CTRL+W | Close the currently opened tab | SQL Editor | |
CTRL+N | Open a new document tab with inherited server and database of the current document tab | SQL Editor |
These shortcuts are default shortcuts. All shortcuts can be customized.