Shortcut / Keyboard keys


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
Print 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
Advertisements