Code editing
1 shortcut
| Action |
Windows |
|
Insert a code snippet Query editor
|
Ctrl + K then Ctrl + X
|
Comments and review
2 shortcuts
| Action |
Windows |
|
Comment out the selection Query editor
|
Ctrl + K then Ctrl + C
|
|
Uncomment the selection Query editor
|
Ctrl + K then Ctrl + U
|
Editing
21 shortcuts
| Action |
Windows |
|
Show Object Explorer Anywhere
|
F8
|
|
Show Object Explorer details Anywhere
|
F7
|
|
Show registered servers Anywhere
|
Ctrl + Alt + G
|
|
Show Template Explorer Anywhere
|
Ctrl + Alt + T
|
|
Show Solution Explorer Anywhere
|
Ctrl + Alt + L
|
|
Show the toolbox Anywhere
|
Ctrl + Alt + X
|
|
Switch full screen mode Anywhere
|
Shift + Alt + Enter
|
|
Run the query Query editor
|
F5
|
|
Parse the query Query editor
|
Ctrl + F5
|
|
Show the estimated execution plan Query editor
|
Ctrl + L
|
|
Cancel the running query Query running
|
Alt + Break
|
|
Include the actual execution plan Query editor
|
Ctrl + M
|
|
Show results in a grid Query editor
|
Ctrl + D
|
|
Show results as text Query editor
|
Ctrl + T
|
|
Switch between the query and the results Query editor
|
F6
|
|
Copy the result grid with headers Results grid
|
Ctrl + Shift + C
|
|
Undo the last edit Query editor
|
Ctrl + Z
|
|
Redo the undone edit Query editor
|
Ctrl + Y
|
|
Refresh the IntelliSense cache Query editor
|
Ctrl + Shift + R
|
|
Delete the word to the left Query editor
|
Ctrl + Backspace
|
|
Delete the word to the right Query editor
|
Ctrl + Delete
|
Files and printing
9 shortcuts
| Action |
Windows |
|
Open a new query window Anywhere
|
Ctrl + N
|
|
Open the new project dialog Anywhere
|
Ctrl + Shift + N
|
|
Open a file Anywhere
|
Ctrl + O
|
|
Open the query designer Query editor
|
Ctrl + Shift + Q
|
|
Close the current document Document open
|
Ctrl + F4
|
|
Open SQL Server Profiler Anywhere
|
Ctrl + Alt + P
|
|
Save the file Query editor
|
Ctrl + S
|
|
Save every file Anywhere
|
Ctrl + Shift + S
|
|
Open Activity Monitor Anywhere
|
Ctrl + Alt + A
|
Formulas and data
1 shortcut
| Action |
Windows |
|
Fill in template parameter values Query editor
|
Ctrl + Shift + M
|
Navigation
6 shortcuts
| Action |
Windows |
|
Send results to a file Query editor
|
Ctrl + Shift + F
|
|
Go to a line Query editor
|
Ctrl + G
|
|
Find the next match Query editor
|
F3
|
|
Find the previous match Query editor
|
Shift + F3
|
|
Navigate back in history Anywhere
|
Ctrl + -
|
|
Navigate forward in history Anywhere
|
Ctrl + Shift + -
|
Paragraphs and lists
1 shortcut
| Action |
Windows |
|
List members Query editor
|
Ctrl + J
|
Search
3 shortcuts
| Action |
Windows |
|
Find text Query editor
|
Ctrl + F
|
|
Replace text Query editor
|
Ctrl + H
|
|
Replace text in files Anywhere
|
Ctrl + Shift + H
|
Selection
4 shortcuts
| Action |
Windows |
|
Describe the selected object with sp_help Query editor
|
Alt + F1
|
|
Make the selection uppercase Query editor
|
Ctrl + Shift + U
|
|
Make the selection lowercase Query editor
|
Ctrl + Shift + L
|
|
Surround the selection with a snippet Query editor
|
Ctrl + K then Ctrl + S
|
Tabs and windows
7 shortcuts
| Action |
Windows |
|
Show the properties window Anywhere
|
F4
|
|
Show the output window Anywhere
|
Ctrl + Alt + O
|
|
Close the current tool window Tool window focused
|
Shift + Esc
|
|
Set or clear a bookmark Query editor
|
Ctrl + K then Ctrl + K
|
|
Go to the next bookmark Query editor
|
Ctrl + K then Ctrl + N
|
|
Go to the previous bookmark Query editor
|
Ctrl + K then Ctrl + P
|
|
Clear every bookmark Query editor
|
Ctrl + K then Ctrl + L
|
View and zoom
1 shortcut
| Action |
Windows |
|
Show or hide the results pane Query editor
|
Ctrl + R
|
From Shortivo at https://shortivo.net/platforms/ssms/. A dot means the maker does not document a key for that system. Nothing on this sheet was converted from one system to another.