SQL Document shortcut keys
Last modified: August 8, 2024
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 |
| 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 |
| Execution History |
CTRL+ALT+H |
Open SQL 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+SPACEC |
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+PAGE UP |
Switch from the current document tab to the previous tab |
| Next Tab |
CTRL+ALT+PAGE DOWN |
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.
'%3e%3cpath%20id='thumb_up_2'%20d='M15%2017H5.5V7L11.5%201L12.1667%201.45833C12.4028%201.625%2012.5833%201.83681%2012.7083%202.09375C12.8333%202.35069%2012.8681%202.61806%2012.8125%202.89583L12.7917%203L12%207H17.5C17.9167%207%2018.2708%207.14583%2018.5625%207.4375C18.8542%207.72917%2019%208.08333%2019%208.5V9.6875C19%209.79861%2018.9896%209.89931%2018.9688%209.98958C18.9479%2010.0799%2018.9167%2010.1736%2018.875%2010.2708L16.3944%2016.0875C16.2703%2016.3625%2016.0833%2016.5833%2015.8333%2016.75C15.5833%2016.9167%2015.3056%2017%2015%2017ZM7%2015.5H15L17.5%209.6875V8.5H10.1667L11.1875%203.4375L7%207.625V15.5ZM5.5%207V8.5H2.5V15.5H5.5V17H1V7H5.5Z'%20fill='%2327282C'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
Yes'%3e%3cpath%20id='thumb_down_2'%20d='M5%203H14.5V13L8.5%2019L7.83333%2018.5417C7.59722%2018.375%207.41667%2018.1632%207.29167%2017.9062C7.16667%2017.6493%207.13194%2017.3819%207.1875%2017.1042L7.20833%2017L8%2013H2.5C2.08333%2013%201.72917%2012.8542%201.4375%2012.5625C1.14583%2012.2708%201%2011.9167%201%2011.5V10.3125C1%2010.2014%201.01042%2010.1007%201.03125%2010.0104C1.05208%209.92014%201.08333%209.82639%201.125%209.72917L3.60417%203.91667C3.71528%203.63889%203.89931%203.41667%204.15625%203.25C4.41319%203.08333%204.69444%203%205%203ZM13%204.5H5L2.5%2010.3125V11.5H9.83333L8.8125%2016.5625L13%2012.375V4.5ZM14.5%2013V11.5H17.5V4.5H14.5V3H19V13H14.5Z'%20fill='%2327282C'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e)
No'%3e%3cpath%20id='Vector'%20d='M4%204V24H24V4H4ZM22%2022H6V9H22V22ZM19%2019H9V18H19V19ZM19%2016H9V15H19V16ZM19%2013H9V12H19V13ZM21%202H2V21H0V0H21V2Z'%20fill='%230071CE'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_676_40052'%3e%3crect%20width='24'%20height='24'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
