Use the following shortcut keys when working with an SQL document or stored procedure.
Cursor Movement keyboard shortcuts | ||
---|---|---|
Command Name | Shortcut Keys | Action |
Open File | Ctrl+O | Open File |
Close | Ctrl+F4 | Close the current window |
Save SQL.sql | Ctrl+S | Save an .sql file |
Save All | Ctrl+Shift+S | Save all the open documents |
Ctrl+P | Print a document | |
Go To | Ctrl+G | Locate certain elements in your document |
Previous SQL | Ctrl+Shift+Up Arrow | Previous SQL statement from history |
Next SQL | Ctrl+Shift+Down Arrow | Next SQL statement from history |
Text Selection keyboard shortcuts | ||
---|---|---|
Command Name | Shortcut Keys | Action |
Toggle Outlining Expansion | Ctrl+M, M | Toggle outlining expansion |
Toggle All Outlining | Ctrl+M, L | Toggle all outlining |
Stop Outlining | Ctrl+M, P | Stop outlining |
Comment Selection | Ctrl+K, C | Comment out the selected lines |
Uncomment Selection | Ctrl+K, U | Uncomment the selected lines |
Bookmark keyboard shortcuts | ||
---|---|---|
Command Name | Shortcut Keys | Action |
Toggle a Bookmark | Ctrl+K,K | Toggle a bookmark on the current line |
Previous Bookmark | Ctrl+K, Ctrl+P | Move the caret to the previous bookmark |
Next Bookmark | Ctrl+K, Ctrl+N | Move the caret to the next bookmark |
Clear All | Ctrl+K,L | Clear all bookmarks in the current document |
Code Editor keyboard shortcuts | ||
---|---|---|
Command Name | Shortcut Keys | Action |
Edit Parameters | Ctrl+Shift+M | Edit parameters |
Execute | F5 | Execute the entire script |
Execute Current Statement | F8 | Execute the query associated with the current document |
Execute To Cursor | Ctrl+Shift+F10 | Execute query before the cursor |
Stop Execution | Alt+Pause | Stop the execution |
Query History | Ctrl+Alt+H | Open the Query History dialog |
Text Manipulation in Code Editor keyboard shortcuts | ||
---|---|---|
Command Name | Shortcut Keys | Action |
Undo | Ctrl+Z | Take one step back |
Redo | Ctrl+Y | Take one step forward |
Delete | Delete | Remove the selected part of the code |
Select All | Ctrl+A | Select the entire SQL document |
Format Document | Ctrl+K, D | Format document |
Format Current Statement | Ctrl+K, S | Format current statement |
Code Completion keyboard shortcuts | ||
---|---|---|
Command Name | Shortcut Keys | Action |
List Members | Ctrl+K, Ctrl+L | Display an object member list |
Parameter Info | Ctrl+Shift+Space | Display parameter info |
Quick Info | Ctrl+K, I | Display brief information about the object |
Word Completion | Ctrl+K, W | Show the list of suggestions |
Refresh Suggestions | Ctrl+Shift+R | Refresh the suggestions |
Document Window keyboard shortcuts | ||
---|---|---|
Command Name | Shortcut Keys | Action |
Start Page | Ctrl+W, S | Open the Start Page |
Database Explorer | Ctrl+W, L | Switch to Database Explorer |
Data Window | Ctrl+W, D | Switch to Data Window |
Data Viewer | Ctrl+W, R | Switch to Data Viewer |
Output | Ctrl+Alt+O | Display the Output window |
Error List | Ctrl+\, E | Display the list of the errors, warnings, and messages. |
Properties | F4 | Show the properties of an object |
Previous Tab | Ctrl+Alt+PgUp | Switch from the current document tab to the previous tab |
Next Tab | Ctrl+Alt+PgDown | Switch from the current document tab to the next tab |
Results as Text | Ctrl+T | Display the query execution results as a text |
Results as Grid | Ctrl+D | Display the query execution results as a grid |
Estimated Execution Plan | Ctrl+L | Show the estimated plan of the execution |
Navigation Bar | Ctrl+F2 | Switch to Navigation Bar |
Redirect Data To Output Window | Ctrl+Shift+T | Show data as text in the Output window |
Cut and Paste keyboard shortcuts | ||
---|---|---|
Command Name | Shortcut Keys | Action |
Cut | Ctrl+X | Cut the selected text and copy it to the clipboard |
Copy | Ctrl+C | Copy the selected text to the clipboard |
Paste | Ctrl+V | Paste the text from the clipboard to the selected part of the document |
All default shortcuts can be customized by clicking Tools in the menu on the top and selecting Customize.