SQL Document shortcut keys
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 |
| Print |
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 |
| Select Current Statement |
Ctrl+Shift+A |
Select the current SQL statement or code block at the cursor position |
| 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 query associated with 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 |
| Query Profiling Mode |
Ctrl+M |
Open the Query Profiling Mode |
| 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.