SQL Server Management Studio Keyboard Shortcuts


By:   |   Updated: 2020-06-09   |   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 SSMS keyboard shortcuts exists and how they can save some time when working with SSMS.

Solution

This article is a quick reference guide to over 120 SQL Server Management Studio (SSMS) keyboard shortcuts.

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

SSMS Keyboard Shortcuts Listed by Shortcut

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

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

SSMS Keyboard Shortcuts Listed by Function

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

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

Note: The list was put together using SSMS version 17.9.1.

Next Steps

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



Last Updated: 2020-06-09


get scripts

next tip button



About the author





Comments For This Article





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

Connect to SQL Servers in another domain using Windows Authentication








get free sql tips
agree to terms


Learn more about SQL Server tools