SQL Server Management Studio Keyboard Shortcuts - Complete List


By:   |   Updated: 2020-05-14   |   Comments   |   Related: 1 | 2 | 3 | 4 | More > SQL Server Management Studio

Problem

SQL Server Management Studio (SSMS) has lots of shortcut keys that can be used to navigate and perform specific tasks. The problem is there are so many of them and a lot of them are hidden away in menus, so unless you go looking for them you might not know what shortcuts exists and how they can save some time when working with SSMS.

Solution

To help with finding and grouping of the available SSMS shortcuts that are available. Two lists have been put together: the first is sorted by the shortcut keys and the second is sorted by the function of the shortcut keys.

The following list was put together using SSMS version 17.9.1.

SSMS Keyboard Shortcuts Listed by Shortcut

Following is a list of SQL Server Management Studio shortcuts listed in shortcut order.

Shortcut Function Shortcut Function
Alt+Break Query - Cancel Executing Query Ctrl+Alt+F1 Tools - Add and Remove Help Content
Alt+Down Arrow Editing - Move Selected Lines Down Ctrl+Alt+F2 Tools - Resource Center
Alt+Right Arrow Intellisense - Complete Word Ctrl+B,Ctrl+I Intellisense - Enabled
Alt+Up Arrow Editing - Move Selected Lines Up Ctrl+Delete Editing - Delete through the end of the line
Alt+D Main Menu - Debug Ctrl+End Editing - End of query window text
Alt+E Main Menu - Edit Ctrl+F4 Navigation - Disconnect and close query window
Alt+F Main Menu - File Ctrl+F5 Query - Parse
Alt+H Main Menu - Help Ctrl+Home Editing - Top of query window text
Alt+N Navigation - New query window Ctrl+K,Ctrl+\ Editing - Delete Horizontal White Space
Alt+P Main Menu - Project Ctrl+K,Ctrl+B Tools - Codes Snippets Manager
Alt+Q Main Menu - Query Ctrl+K,Ctrl+C Editing - Comment Selection
Alt+T Main Menu - Tools Ctrl+K,Ctrl+F Bookmarks - New Folder
Alt+V Main Menu - View Ctrl+K,Ctrl+H Bookmarks - Add Task List Shortcut
Alt+W Main Menu - Window Ctrl+K,Ctrl+I Intellisense - Quick Info
Alt+F1 Query Shortcut - sp_help Ctrl+K,Ctrl+K Bookmarks - Toggle Bookmark
Alt+F4 Navigation - Exit Ctrl+K,Ctrl+L Bookmarks - Clear
Alt+F5 Debug - Start Debugging Ctrl+K,Ctrl+N Bookmarks - Next Bookmark
Alt+F6 Navigation - Move between windows Ctrl+K,Ctrl+P Bookmarks - Previous
Atl+F7 Navigation - Move between windows - popup Ctrl+K,Ctrl+S Intellisense - Surround Width
Alt+F8 Open Server in Object Explorer Ctrl+K,Ctrl+U Editing - Uncomment Selection
Alt+F9,B Debug - Function Breakpoint Ctrl+K,Ctrl+W Window - Bookmark Explorer
Ctrl+A Editing - Select All Ctrl+K,Ctrl+X Tools - Insert Snippet
Ctrl+C Editing - Copy Ctrl+Shift+A Project - Add New Item
Ctrl+D Query - Results to Grid Ctrl+Shift+F Query - Results to File
Ctrl+E Query - Execute query Ctrl+Shift+H Search - Replace in Files
Ctrl+F Search - Quick Find Ctrl+Shift+L Editing - Make Lowercase
Ctrl+G Navigation - Go To Ctrl+Shift+M Query - Specify Values for Template Parameters
Ctrl+H Search - Quick Replace Ctrl+Shift+N Project - New
Ctrl+I Search - Incremental Search Ctrl+Shift+O Open Project Solution
Ctrl+J Intellisense - List Members Ctrl+Shift+Q Tools - Design Query in Editor
Ctrl+L Query - Display Estimated Execution Plan Ctrl+Shift+R Intellisense - Refresh Local Cache
Ctrl+M Query - Include Actual Execution Plan (toggle) Ctrl+Shift+S Query - Save All
Ctrl+N Query - New Query with Current Connection Ctrl+Shift+U Editing - Make Uppercase
Ctrl+O Open File Ctrl+Shift+V Editing - Cycle Clipboard Ring
Ctrl+P Print Ctrl+Shift+Del Editing - Clear the active Editor pane
Ctrl+Q Search - Quick Launch Ctrl+Shift+End Editing - Select all text from cursor to end
Ctrl+R Query - Show Results Pane (toggle) Ctrl+Shift and arrow keys Editing - Select section of text
Ctrl+S Query - Save query Ctrl+Shift+F9 Debug - Delete All Breakpoints
Ctrl+T Query - Results To Text Ctrl+Shift+Home Editing - Select all text from cursor to top
Ctrl+U Navigation - Change database Ctrl+Shift+Space Intellisense - Parameter Info
Ctrl+V Editing - Paste Ctrl+Shift+K,Ctrl+Shift+N Bookmarks - Next Bookmark in Folder
Ctrl+W Editing - Select word Ctrl+Shift+K,Ctrl+Shift+P Bookmarks - Previous Bookmark in Folder
Ctrl+X Editing - Cut Del Editing - Delete text
Ctrl+Y Editing - Redo F1 Help
Ctrl+Z Editing - Undo F3 Search - Repeat Last Search
Ctrl+- Navigation - Navigate Query Windows Backward F4 Window - Properties Window
Ctrl+\,Ctrl+E Window - Error List F5 Query - Execute
Ctrl+1 Query Shortcut - sp_who F6 Navigation - Move between windows Next Pane
Ctrl+2 Query Shortcut - sp_lock F7 Window - Object Explorer Details
Ctrl+Alt+A Window - Activity Monitor F8 Window - Object Explorer
Ctrl+Alt+B Debug - Breakpoints Window F9 Debug - Toggle Breakpoint
Ctrl+Alt+G Window - Registered Servers F10 Debug - Step Over
Ctrl+Alt+I Debug - Immediate Window F11 Debug - Step Into
Ctrl+Alt+K Window - Task List Shift+Alt+A Project - Add Existing Item
Ctrl+Alt+L Window - Solution Explorer Shift+Alt+Enter Navigation - Full Screen
Ctrl+Alt+O Window - Output Shift+Alt+S Query - Include Client Statistics
Ctrl+Alt+P Tools - Trace Query in SQL Server Profiler Shift+F1 Help
Ctrl+Alt+R Window - Web Browser Shift+F3 Search - Repeat Last Search
Ctrl+Alt+T Window - Template Explorer Shift+F6 Navigation - Move between windows Previous Pane
Ctrl+Alt+X Window - Toolbox Shift+Tab Editing - Indent decrease
Ctrl+Alt+Space Intellisense - Toggle Completion Mode Tab Editing - Indent increase

SSMS Keyboard Shortcuts Listed by Function

Following is a list of SQL Server Management Studio shortcuts listed in function order.

Function Shortcut Function Shortcut
Bookmarks - Add Task List Shortcut Ctrl+K,Ctrl+H Navigation - Disconnect and close query window Ctrl+F4
Bookmarks - Clear Ctrl+K,Ctrl+L Navigation - Exit Alt+F4
Bookmarks - New Folder Ctrl+K,Ctrl+F Navigation - Full Screen Shift+Alt+Enter
Bookmarks - Next Bookmark Ctrl+K,Ctrl+N Navigation - Go To Ctrl+G
Bookmarks - Next Bookmark in Folder Ctrl+Shift+K,Ctrl+Shift+N Navigation - Move between windows Alt+F6
Bookmarks - Previous Ctrl+K,Ctrl+P Navigation - Move between windows - popup Atl+F7
Bookmarks - Previous Bookmark in Folder Ctrl+Shift+K,Ctrl+Shift+P Navigation - Move between windows Next Pane F6
Bookmarks - Toggle Bookmark Ctrl+K,Ctrl+K Navigation - Move between windows Previous Pane Shift+F6
Debug - Breakpoints Window Ctrl+Alt+B Navigation - Navigate Query Windows Backward Ctrl+-
Debug - Delete All Breakpoints Ctrl+Shift+F9 Navigation - New query window Alt+N
Debug - Function Breakpoint Alt+F9,B Open File Ctrl+O
Debug - Immediate Window Ctrl+Alt+I Open Project Solution Ctrl+Shift+O
Debug - Start Debugging Alt+F5 Open Server in Object Explorer Alt+F8
Debug - Step Into F11 Print Ctrl+P
Debug - Step Over F10 Project - Add Existing Item Shift+Alt+A
Debug - Toggle Breakpoint F9 Project - Add New Item Ctrl+Shift+A
Editing - Clear the active Editor pane Ctrl+Shift+Del Project - New Ctrl+Shift+N
Editing - Comment Selection Ctrl+K,Ctrl+C Query - Cancel Executing Query Alt+Break
Editing - Copy Ctrl+C Query - Display Estimated Execution Plan Ctrl+L
Editing - Cut Ctrl+X Query - Execute F5
Editing - Cycle Clipboard Ring Ctrl+Shift+V Query - Execute query Ctrl+E
Editing - Delete Horizontal White Space Ctrl+K,Ctrl+\ Query - Include Actual Execution Plan (toggle) Ctrl+M
Editing - Delete text Del Query - Include Client Statistics Shift+Alt+S
Editing - Delete through the end of the line Ctrl+Delete Query - New Query with Current Connection Ctrl+N
Editing - End of query window text Ctrl+End Query - Parse Ctrl+F5
Editing - Indent decrease Shift+Tab Query - Results to File Ctrl+Shift+F
Editing - Indent increase Tab Query - Results to Grid Ctrl+D
Editing - Make Lowercase Ctrl+Shift+L Query - Results To Text Ctrl+T
Editing - Make Uppercase Ctrl+Shift+U Query - Save All Ctrl+Shift+S
Editing - Move Selected Lines Down Alt+Down Arrow Query - Save query Ctrl+S
Editing - Move Selected Lines Up Alt+Up Arrow Query - Show Results Pane (toggle) Ctrl+R
Editing - Paste Ctrl+V Query - Specify Values for Template Parameters Ctrl+Shift+M
Editing - Redo Ctrl+Y Query Shortcut - sp_help Alt+F1
Editing - Select All Ctrl+A Query Shortcut - sp_lock Ctrl+2
Editing - Select all text from cursor to end Ctrl+Shift+End Query Shortcut - sp_who Ctrl+1
Editing - Select all text from cursor to top Ctrl+Shift+Home Search - Incremental Search Ctrl+I
Editing - Select section of text Ctrl+Shift and arrow keys Search - Quick Find Ctrl+F
Editing - Select word Ctrl+W Search - Quick Launch Ctrl+Q
Editing - Top of query window text Ctrl+Home Search - Quick Replace Ctrl+H
Editing - Uncomment Selection Ctrl+K,Ctrl+U Search - Repeat Last Search F3
Editing - Undo Ctrl+Z Search - Repeat Last Search Shift+F3
Help F1 Search - Replace in Files Ctrl+Shift+H
Help Shift+F1 Tools - Add and Remove Help Content Ctrl+Alt+F1
Intellisense - Complete Word Alt+Right Arrow Tools - Codes Snippets Manager Ctrl+K,Ctrl+B
Intellisense - Enabled Ctrl+B,Ctrl+I Tools - Design Query in Editor Ctrl+Shift+Q
Intellisense - List Members Ctrl+J Tools - Insert Snippet Ctrl+K,Ctrl+X
Intellisense - Parameter Info Ctrl+Shift+Space Tools - Resource Center Ctrl+Alt+F2
Intellisense - Quick Info Ctrl+K,Ctrl+I Tools - Trace Query in SQL Server Profiler Ctrl+Alt+P
Intellisense - Refresh Local Cache Ctrl+Shift+R Window - Activity Monitor Ctrl+Alt+A
Intellisense - Surround Width Ctrl+K,Ctrl+S Window - Bookmark Explorer Ctrl+K,Ctrl+W
Intellisense - Toggle Completion Mode Ctrl+Alt+Space Window - Error List Ctrl+\,Ctrl+E
Main Menu - Debug Alt+D Window - Object Explorer F8
Main Menu - Edit Alt+E Window - Object Explorer Details F7
Main Menu - File Alt+F Window - Output Ctrl+Alt+O
Main Menu - Help Alt+H Window - Properties Window F4
Main Menu - Project Alt+P Window - Registered Servers Ctrl+Alt+G
Main Menu - Query Alt+Q Window - Solution Explorer Ctrl+Alt+L
Main Menu - Tools Alt+T Window - Task List Ctrl+Alt+K
Main Menu - View Alt+V Window - Template Explorer Ctrl+Alt+T
Main Menu - Window Alt+W Window - Toolbox Ctrl+Alt+X
Navigation - Change database Ctrl+U Window - Web Browser Ctrl+Alt+R
Next Steps

Take a look at these other SQL Server Management Studio Tips:



Last Updated: 2020-05-14


get scripts

next tip button



About the author




More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download


Recommended Reading

Assign shortcuts to commands in SQL Server Management Studio

SQL Server Management Studio keyboard shortcuts (Part 1 of 2)

SSMS keyboard shortcuts (Part 2 of 2)

Display Line Numbers in a SQL Server Management Studio Query Window

Different Options for Query Results in SQL Server Management Studio





get free sql tips
agree to terms


Learn more about SQL Server tools