SQL Server Management Studio (SSMS) – Keyboard Shortcut Keys

Leave a comment (1) Go to comments

Shortcut / Keyboard keys are very important role to increase the productivity. In case DBA’s are spending at least 6 hours on daily basis on SQL Server Management Studio, which is true in most of the cases, we love, if we get shortcut keys, to avoid using mouse to increase productivity

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

I am going to post another 4-5 articles, which will discuss about


  • SSMS Text Selection Keyboard Shortcuts
  • SSMS Bookmark Keyboard Shortcuts
  • SSMS Tree Control Keyboard Shortcuts
  • SSMS Code Editor Keyboard Shortcuts
  • SSMS Text Manipulation in Code Editor Keyboard Shortcuts
  • SSMS Microsoft IntelliSense Keyboard Shortcuts
  • SSMS Document Window and Browser Keyboard Shortcuts
  • SSMS Solution Explorer Keyboard Shortcuts
  • SSMS Help and Books Online Keyboard Shortcuts
  • SSMS Search Keyboard Shortcuts
  • SSMS Cut and Paste Keyboard Shortcuts
  • SSMS Log Viewer Keyboard Shortcuts
  • SSMS Activity Monitor Keyboard keys
  • SSMS Replication Monitor Keyboard Shortcuts
  • SSMS Replication Conflict Viewer Keyboard Shortcuts

Tags : Keyboard Shortcut Keys,SSMS Shortcut Keys, SSMS Keyboard Keys, SQL Server Management Studio Keyboard Shortcut Keys,SQL Server Management Studio Shortcut Keys, SQL Server Management Studio Keyboard Keys,

EOF - SQL Server Management Studio (SSMS) – Keyboard Shortcut Keys, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

1 Comments.

  1. Great resource but I would like to point out that SSMS 2008 now defaults to “Standard” for keyboard shortcuts. You would need to change it to SQL Server 2000 to use the above shortcuts. Source:

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.