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 |

I also tend to add ctrl+alt+U to change server connection

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 |

Some great ones to add (count, and top 100) are explained here: michaelscalise.com