SSMS Shortcuts
See also: cheatsheet
| Key Combination | Action |
|---|---|
| Ctrl + U | “USE database” dropdown |
| Ctrl + R | Show/hide results pane |
| Alt + Shift + [Arrow] | Block highlighting |
| Ctrl + L | Get estimated execution plan |
| Ctrl + M | Include actual execution plan |
| F6 | Switch query/results/messages tabs |
| F7 | Object Explorer Details |
| Ctrl + Shift + U | UPPERCASE selected text |
| Ctrl + Shift + L | lowercase selected text |
| Ctrl + G | Go to… (line number) |
| Ctrl + Tab | Switch query tabs (forward) |
| Ctrl + Shift + Tab | Switch query tabs (backward) |
| Shift + Alt + Enter | Toggle full screen |
| Ctrl + (K,C) | Comment selected text |
| Ctrl + (K,U) | Uncomment selected text |
| Ctrl + ] | Go to corresponding BEGIN/END |
| Alt + F8 | Open Object Explorer for current query |
| Ctrl + Shift + V | Cycle clipboard ring |
| Ctrl + Shift + M | Template replacement |
| Ctrl + Shift + R | Refresh IntelliSense cache |
| Ctrl + Alt + T | Open Template Explorer |
| Ctrl + Alt + R | Open integrated web browser |
SSMS query shortcuts
Configure these in TOOLS > OPTIONS > KEYBOARD > QUERY SHORTCUTS
Mark an identifier to use as parameter.
| Key Combination | Stored Procedure |
|---|---|
| Alt + F1 | sp_help |
| Ctrl + F1 | |
| Ctrl + 1 | sp_who |
| Ctrl + 2 | sp_lock |
| Ctrl + 3 | |
| Ctrl + 4 |