Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (dMVP, Microsoft Partne)
  • When: 22 Apr 2010 2:57 AM
  • Last revision by (aMicrosof)
  • When: 29 May 2013 1:04 AM
  • Revisions: 24
  • Comments: 6
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SQL Server Management Studio Keyboard Shortcuts

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

, , , , , , , [Edit tags]
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
  • 28 May 2013 9:22 AM

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

  • 23 Feb 2013 7:03 AM

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

  • 23 Feb 2013 7:01 AM

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

  • 22 Jul 2010 3:29 PM

    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.

  • 27 May 2010 12:40 PM

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

  • 17 May 2010 3:53 PM

    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
  • Posted by
    on 17 May 2010 3:53 PM

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

  • Posted by
    on 27 May 2010 12:40 PM

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

  • Posted by
    on 22 Jul 2010 3:29 PM

    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.

  • Posted by
    on 23 Feb 2013 7:01 AM

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

  • Posted by
    on 23 Feb 2013 7:03 AM

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

  • Posted by
    on 28 May 2013 9:22 AM

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

Page 1 of 1 (6 items)