Share via


SQL Server Management Studio Keyboard Shortcuts

This is a partial list of keyboard shortcuts for [[articles:SQL Server Management Studio|SQL Server Management Studio (SSMS)]].

Hot Key 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 or line
CTRL + K, U Uncomment Selection or line
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
CTRL + 1 Execute sp_who
CTRL + 2 Execute sp_lock
CTRL + SHIFT + ALT + 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


Other Languages