Here is list of Shortcut keys to work with SSMS handy.
Action | SSMS-Shortcut Key |
Move to the SQL Server Management Studio menu bar | ALT |
Activate the menu for a tool component | ALT+HYPHEN |
Display the context menu | SHIFT+F10 |
Display the New File dialog box to create a file | CTRL+N |
Display the New Project dialog box to create a new project | CTRL+SHIFT+N |
Display the Open File dialog box to open an existing file | CTRL+O |
Display the Open Project dialog box to open an existing project | CTRL+SHIFT+O |
Display the Add New Item dialog box to add a new file to the current project | CTRL+SHIFT+A |
Display the Add Existing Item dialog box to add an existing file to the current project | ALT+SHIFT+A |
Display the Query Designer | CTRL+SHIFT+Q |
Close a menu or dialog box, canceling the action | ESC |
Clear all bookmarks | CTRL-SHIFT-F2 |
Insert or remove a bookmark (toggle) | CTRL+F2 |
Move to next bookmark | F2 |
Move to previous bookmark | SHIFT+F2 |
Cancel a query | ALT+BREAK |
Connect | CTRL+O |
Disconnect | CTRL+F4 |
Disconnect and close child window | ALT+F4 |
Database object information | ALT+F1 |
Clear the active Editor pane | CTRL+SHIFT+DEL |
Comment out code | CTRL+SHIFT+C |
Copy | CTRL+C or Ctrl+Insert |
Cut | CTRL+X or Shift+Del |
Decrease indent | SHIFT+TAB |
Delete through the end of a line in the Editor pane | CTRL+DEL |
Find | CTRL+F |
Go to a line number | CTRL+G |
Increase indent | TAB |
Make selection lowercase | CTRL+SHIFT+L |
Make selection uppercase | CTRL+SHIFT+U |
Paste | CTRL+V or Shift+Insert |
Remove comments | CTRL+SHIFT+R |
Repeat last search or find next | F3 |
Replace | CTRL+H |
Select all | CTRL+A |
Undo | CTRL+Z |
Execute a query | F5 or Ctrl + E |
Help for Query Analyzer | F1 |
Help for the selected Transact-SQL statement | SHIFT+F1 |
Switch between query and result panes | F6 |
Switch panes | Shift+F6 |
Window Selector | CTRL+W |
New Query window | CTRL+N |
Object Browser (show/hide) | F8 |
Object Search | F4 |
Parse the query and check syntax | CTRL+F5 |
CTRL+P | |
Display results in grid format | CTRL+D |
Display results in text format | CTRL+T |
Move the splitter | CTRL+B |
Save results to file | CTRL+SHIFT+F |
Show Results pane (toggle) | CTRL+R |
Save | CTRL+S |
Insert a template | CTRL+SHIFT+INSERT |
Replace template parameters | CTRL+SHIFT+M |
Display estimated execution plan | CTRL+L |
Display execution plan (toggle ON/OFF) | CTRL+K |
Index Tuning Wizard | CTRL+I |
Show client statistics | CTRL+SHIFT+S |
Show server trace | CTRL+SHIFT+T |
Use database | CTRL+U |
