SQL Server Management Studio Keyboard Shortcuts

SQL Server Management Studio Keyboard Shortcuts

This is a partial list of keyboard shortcuts for SQL Server Management Studio (SSMS).

Key chord Effect
ALT + N New query window
CTRL + F4 Close current query window
CTRL + W Highlight the word where the cursor is currently located
CTRL + Shift + U Convert selected text to UPPER CASE
CTRL + Shift + L

Convert selected text to lower case

F5
Execute the selected query or if nothing is selected, then execute the entire content
CTRL + F5 Parse the selected query or if nothing is selected, then parse the entire content
CTRL + T Results to Text
CTRL + D Results to Grid
CTRL + SHIFT + F Results to File
CTRL + R Toggle display of results pane
F7 Display Object Explorer Details
CTRL + ALT + G Display Registered Servers pane
CTRL + K, C Comment Selection
CTRL + K, U Uncomment Selection
CTRL + TAB Cycle through open query windows and panes
F6 / SHIFT + F6 Cycle through the query text, resultsets and messages pane inside a query window
CTRL + J Display Intellisense menu (Only in SSMS in SQL Server 2008 and later)
CTRL + ALT + L Display Solution Explorer
CTRL + SHIFT + R Refresh Intellisense cache
ALT + F1 Execute sp_help in the current results pane
CTRL + 1 Execute sp_who
CTRL + 2 Execute sp_lock
CTRL + U
To go to drop down list of Databases
CTRL + L
Display the Execution Plan

For the full list, see the Books Online topic http://msdn.microsoft.com/en-us/library/ms174205.aspx


See Also

Leave a Comment
  • Please add 4 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Carsten Siemens edited Revision 20. Comment: Added tag: en-US

  • Rahul Garware edited Revision 19. Comment: Removed <p>

  • Rahul Garware edited Revision 18. Comment: Added CTRL+F5 and edited F5 description

  • Rick Byham edited Revision 15. Comment: This is only a partial list. There are more, and two keyboard schemes. This is described in Books Online.

  • Ed Price MSFT edited Revision 14. Comment: Added "See Also" section.

  • Ed Price MSFT edited Revision 12. Comment: Removed link to SSMS acronym page.

Page 1 of 1 (6 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price MSFT edited Revision 12. Comment: Removed link to SSMS acronym page.

  • Ed Price MSFT edited Revision 14. Comment: Added "See Also" section.

  • Rick Byham edited Revision 15. Comment: This is only a partial list. There are more, and two keyboard schemes. This is described in Books Online.

  • Rahul Garware edited Revision 18. Comment: Added CTRL+F5 and edited F5 description

  • Rahul Garware edited Revision 19. Comment: Removed <p>

  • Carsten Siemens edited Revision 20. Comment: Added tag: en-US

Page 1 of 1 (6 items)