SQL Document shortcut keys

Last modified: September 6, 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
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.