380+ SQL Server Management Studio (SSMS) Shortcuts For Windows

SQL Server Management Studio (SSMS) Shortcuts:

SQL Server Management Studio is a free Windows application. It can be used for managing and configuring the components within the Microsoft Excel SQL. In this article, we are going to see the list of shortcuts for the SQL Server Management Studio (SSMS).

SQL Server Management
SQL Server Management


Last Updated On Aug 3, 2020.

Download SQL Server Management Studio (SSMS) Shortcuts for Offline Study Here: SQL Server Management Studio (SSMS) Shortcuts.PDF

Shortcut Function
Alt It will Move to the SQL Server Management Studio menu bar
Alt++ It is Used to Activate the menu for a tool component
Shift+F10 This Shortcut will Display the context menu
CTRL+N Used to Display the New File dialog box to create a file
CTRL+Shift+N It is Used to Display the New Project dialog box to create a new project
CTRL+O It helps to display the Open File dialog box to open an existing file
CTRL+Shift+G Used to display the Open File dialog box to open an existing file
CTRL+Shift+O It is Used to Display the Open Project dialog box to open an existing project
CTRL+Shift+A Helps to Display the Add New Item dialog box to add a new file to the current project
Shift+Alt+A It will Display the Add Existing Item dialog box to add an existing file to the current project
CTRL+Shift+Q Used to Display the Query Designer
Esc Used to Close a menu or dialog box, canceling the action

Windows Management Shortcuts:

Shortcut Function
CTRL+F4 This Shortcut will Close the current MDI child window
Esc Used to Close a menu or dialog box cancels an operation in progress or focuses on the current document window
CTRL+P Used to Print
Alt+F4 It is Used to Exit
Shift+Alt+Enter It will Toggle full-screen mode
Shift+Esc Used to Close the current tool window
CTRL+F6 Used to Cycle through the next MDI child windows
CTRL+Tab It will Display the IDE navigator with the first document window selected
CTRL+Shift+Tab This Shortcut is Used to Cycle through the previous MDI child windows
CTRL+F2 Helps to Move the insertion point to the drop-down bar located at the top of the code editor when the editor is in Code view or Server Code view
Shift+Alt Used to Move to the current tool window toolbar
Alt+F7 It will Display the IDE navigator with the first tool window selected
Alt+F6 Used to Move to the next tool window
F6 Used to Move to the next tool window in the Database Engine Query Editor
Shift+Alt+F7 It will Move to the previous tool window
Alt+F6 It is Used to Move to the next pane of a split-pane view of a single document
Shift+Alt+F6 Used to Move to the previously selected window
Shift+F6 It will move to the next pane of a split-pane view of a single document in the Database Engine Query Editor
Shift+F6 Used to Move to the previous pane of a split-pane view of a single document
Alt+ Helps to Display the dock menu
CTRL+Alt+ Used to Display a popup listing all open windows
CTRL+O This Shortcut Opens a new query editor window
F8 Used to Display Object Explorer
CTRL+Alt+G It will Display Registered Servers
CTRL+Alt+T It is Used to Display Template Explorer
CTRL+Alt+L Used to Display Solution Explorer
F7 It will Display the Summary Window
F4 Used to Display the Properties Window
CTRL+Alt+O It is Used to Display the Output window
CTRL+\ Then T: It will Display the Task List window
CTRL+\ Then CTRL+T: Used to Display the Task List window
F6 Used to Toggle between Object Explorer Details list view and Object Explorer Details property pane
Tab then UP arrow or DOWN arrow: Control the splitter bar that separates the Object Explorer Details list view and Object Explorer Details property pane to adjust the size of the display pane
CTRL+Alt+X It will Display the Toolbox
CTRL+K Then CTRL+W: Used to Display the Bookmarks Window
CTRL+Alt+R This Shortcut will Display the Browser Window
Shift+Alt+F10 Used to Display a smart tag menu of common commands for Web server controls in the HTML designer
CTRL+\ Then CTRL+E It will Display the Error List Window (Transact-SQL Editor only)
CTRL+\ E This will Display a smart tag menu of common commands for Web server controls in the HTML designer
CTRL+\ Then E Used to Display the Error List Window (Transact-SQL Editor only)
CTRL+Shift+F12 Used to Move to the next entry in the Error List window (Transact-SQL Editor only)
ALT+ It will display the previous page in the viewing history. Available only in the Web browser window
ALT+ Used to Display the next page in the viewing history. Available only in the Web browser window

Cursor Movement Shortcuts:

Shortcut Function
It is Used to Move the cursor left
Used to Move the cursor right
Helps to move the cursor up
Used to Move the cursor down
Home It Will Move the cursor to the beginning of the line
End Used to Move the cursor to the end of the line
CTRL+Home It will Move the cursor to the beginning of the document
CTRL+End Used to Move the cursor to the end of the document
PgUp This Shortcut is Used to Move the cursor up one screen
PgDn Used to Move the cursor down one screen
CTRL+ It will move the cursor one word to the right
CTRL+ It Moves the cursor one word to the left
Shift+F8 This Shortcut Returns the cursor to the last item
CTRL+PgUp It Moves the cursor to the top of the document
CTRL+PgUp It will move to the previous tab in the document
CTRL+PgDn Used to Move the cursor to the bottom of the document
CTRL+PgDn It is Used to Move to the next tab in the document

Text Selection Shortcuts:

Shortcut Function
CTRL+Shift+Home This Shortcut will Select text from the cursor to the beginning of the document
CTRL+Shift+End Used to Select text from the cursor to the end of the document
Shift+Home It is Used to Select text from the cursor to the start of the current line
Shift+Alt+Home It Moves the cursor to the start of the current line and extends the column selection
Shift+End It will Select text from the cursor to the end of the current line
Shift+Alt+End It Moves the cursor to the end of the line, extending the column selection
Shift+ Used to Select text down line by line starting from the cursor
Shift+CTRL+Del This will move the cursor down one line, extending the column selection { Note: I’m not sure if the below shortcut is correct. It’s listed in Microsoft’s documents. Please let me know in the comments if you know the correct one. }
Shift+ It Moves the cursor one character to the left and extends the selection
Shift+Alt+ Used to Move the cursor one character to the left and extends the column selection
Shift+ It is Used to Move the cursor one character to the right and extends the selection
Shift+Alt+ It Moves the cursor one character to the right and extends the column selection
Shift+ Used to ARROW Select text up line by line starting from the cursor
Shift+Alt+ It will move the cursor up one line, extending the selection
Shift+PgUp Used to Extend selection one page up
Shift+PgDn It is Used to Extend selection one page down
CTRL+A Used to select the entire current document
CTRL+W It is Used to Select the word containing the cursor, or the closest word
CTRL+= This Shortcut is used to Select the current location in the editor, back to the previous location in the editor
CTRL+Shift+PgUp It will extend the selection to the top of the current window
CTRL+Shift+PgDn It is Used to Move the cursor to the last line in view, extending the selection
CTRL+Shift+ Used to Extend the selection one word to the right
CTRL+Shift+ It is Used to Extend the selection one word to the left
CTRL+Shift+Alt+ It will Move the cursor to the right one word, extending the selection
CTRL+Shift+Alt+ Used to Move the cursor to the left one word, extending the selection
CTRL+Shift+] It is Used to Move the cursor to the next brace, extending the selection
CTRL+= Helps to Select the text from the current location of the cursor to the Navigate Backward CTRL+ location.
CTRL+ It will Go back to the previous document or window in the navigation history
CTRL+Shift+ Used to Go forward to the next document or window in the navigation history
CTRL+K Then CTRLA: It will Swap the anchor and endpoints of the current selection
CTRL+Shift+PgUp It Moves the cursor to the first line in view, extending the selection
CTRL+Shift+PgDn Used to Move the cursor to the last line in view, extending the selection

Bookmark Shortcuts:

Shortcut Function
CTRL+K then CTRL+K: It will Set or remove a bookmark at the current line
CTRL+K then CTRL+N: Go to Next bookmark
CTRL+Shift+K then CTRL+Shift+N: The current bookmark is in a folder and moves to the next bookmark in the folder. Bookmarks outside the folder are skipped. If the bookmark is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains a folder, bookmarks in folders are skipped
CTRL+K then CTRL+P: Move to the Previous bookmark
CTRL+Shift+K then CTRL+Shift+P: The current bookmark is in a folder, moves to the next bookmark in the folder. Bookmarks outside the folder are skipped. If the bookmark is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains a folder, bookmarks in folders are skipped.
CTRL+K then CTRL+L: It will Clear bookmarks

Tree Control Shortcuts:

Shortcut Function
Used to Collapse tree nodes on the numeric keypad
* It is Used to Expand all tree nodes on the numeric keypad
CTRL+ Used to Scroll the tree control up in the window
CTRL+ It is Used to Scroll the tree control down in the window

Code Editor Shortcuts:

Shortcut Function
Shift+Alt+Enter It will Toggle the full-screen display
CTRL+ Used to Scroll text up one line
CTRL+ It is Used to Scroll text down one line
CTRL+ZorAlt+Backspace This Shortcut will Reverse the last editing action
CTRL+Shift+ZorCTRL+YorAlt+Shift+Backspace It is Used to Restore the previously undone edit
CTRL+S This Shortcut will Save the selected item
CTRL+Shift+S Used to Save all
CTRL+F4 Close
CTRL+P Print
Alt+F4 Exit
CTRL+Shift+W It will open the current file in a browser
CTRL+Shift+Del Used to Delete all text in the current file
CTRL+G It is Used to Display the Go To Line dialog box
CTRL++ Used to Display the Navigate To dialog box.
Tab This Shortcut will Increase line indent
Shift+Tab Used to Decrease line indent
CTRL+Shift+U It is Used to Make the selected text upper case
CTRL+U It will Make the selected text lower case
CTRL+K then CTRL+C: It will Make the selected text a comment
CTRL+K then CTRL+U: Used to Uncomment the selected text
CTRL+N It is Used to Open a new query with current connection
Alt+F8 Used to Open database in Object Explorer
CTRL+Shift+M This Shortcut will Specify values for template parameters
F5orCTRL+Shift+E Used to Run the selected portion of the query editor or the entire query editor if nothing is selected
CTRL+F5 This Shortcut will Parse the selected portion of the query editor or the entire query editor if nothing is selected
CTRL+Shift+Alt+L This will Display the estimated execution plan
Alt+Break Used to Cancel the executing query
CTRL+Shift+Alt+M It is Used to Include actual execution plan in the query output
CTRL+Shift+D Show Output results in a grid
CTRL+T It will Show Output results in text format
CTRL+Shift+T Produce Output results to a file
CTRL+R Used to Show or hide the query results pane
CTRL+Shift+Alt+R It is Used to Show the query results pane
F6 Used to Toggle between query and results pane
CTRL+Shift+C It will Copy the result grid and headers to the clipboard
Alt+F6 Used to Move to the next active window in Management Studio
CTRL+Alt+P It will Open SQL Server Profiler
CTRL+Shift+Q Used to Display the Query Designer dialog from the query editor window
Alt+F1 It is Used to Run the sp_help system stored procedure
CTRL+1 Used to Run the sp_who system stored procedure
CTRL+2 Helps to Run the sp_lock system stored procedure
CTRL+3orCTRL+4or
CTRL+5orCTRL+6or
CTRL+7orCTRL+8or
CTRL+9orCTRL+0
Used to Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

Text Manipulation in Code Editor Shortcuts:

Shortcut Function
EnterorShift+Enter Used to Insert a new line
CTRL+T It is Used to Swap the characters on either side of the cursor (Does not apply to the SQL Editor)
Del Used to Delete one character to the right of the cursor
BackspaceorShift+Backspace This Shortcut is Used to Delete one character to the left of the cursor
CTRL+K then C: Used to Delete whitespace in the selection, or deletes whitespace adjacent to the cursor if there is no selection
Tab It will Insert the number of spaces configured for the editor
CTRL+Enter Used to Insert a blank line above the cursor
CTRL+Shift+Enter It will Insert a blank line below the cursor
CTRL+Shift+L Used to Change the selected text to lowercase
CTRL+Shift+U It is Used to Change the selected text to uppercase
Insert Used to Toggle between insert mode and overtype mode
Shift+Tab It will Move selected lines to the left on tab stop
CTRL+Del This Shortcut will Delete the word to the right of the cursor
CTRL+Backspace Used to Delete the word to the left of the cursor
CTRL+Shift+T It will Transpose the words on either side of the cursor (Does not apply to the SQL Editor)
Shift+Alt+T It Moves the line containing the cursor below the next line
CTRL+K then CTRL+D: This Shortcut Applies the indenting and space formatting for the language specified on the Formatting pane of the language in the Text Editor section of the Options dialog. Available only in the text editor
CTRL+KthenCTRL+F Used to Correctly indents the selected lines of code based on the surrounding lines of code
CTRL+KthenCTRL+H Used to Set or remove a shortcut in the current line
CTRL+KthenCTRL+U This is Used to Remove the comment syntax from the current line
CTRL+RthenCTRL+W This Shortcut Shows or hides spaces and tabs
CTRL+FthenCTRL+W It Enables or disables word wrap in an editor
CTRL+MthenCTRL+A Used to Collapse all outlining regions to show just the outermost groups in the hierarchy
CTRL+MthenCTRL+S This Shortcut is Used to Collapse the currently selected outlining region
CTRL+MthenCTRL+X It Expands all outlining regions on the page
CTRL+MthenCTRL+E It will Expand the currently selected outlining region
CTRL+MthenCTRL+O Used to Collapse existing outlining regions
CTRL+MthenCTRL+H This Shortcuts Hides the selected text. A signal icon marks the location of the hidden text
CTRL+MthenCTRL+L Toggles all text sections previously marked as hidden between the hidden and display states
CTRL+MthenCTRL+M Used to Toggle the currently selected hidden text section between the hidden and display states
CTRL+MthenCTRL+P It Removes all outlining information in the document
CTRL+MthenCTRL+U Used to Remove the outlining information for the currently selected region

Transact – SQL Debugger Shortcuts:

Shortcut Function
Alt+F5 Used to Start or continue debugging
Shift+F5 It is Used to Stop debugging
F11 Step into
F10 Step over
Shift+F11 Step out
Shift+Alt+F11 Used to Step into a specific statement
CTRL+3 It will Set next statement
Alt+Num Lock This Shortcut will Show the next statement
CTRL+F10 Used to Implement the Run To Cursor command
CTRL+Alt+QorShift+F9 It is Used to Display the QuickWatch dialog box
F9 Used to Toggle breakpoint
CTRL+F9 This Shortcut will Enable breakpoint
Alt+F9thenD D is Used to Delete the breakpoint that Only available in the Breakpoints window
Alt+F9thenL L will Open the Edit breakpoint labels dialog that Only available in the Breakpoints window
CTRL+Shift+F9 Used to Delete all breakpoints
CTRL+Alt+B It is Used to Display the Breakpoints window
CTRL+Alt+Break Used to Break all
CTRL+B It is Used to Break at function
CTRL+Alt+Wthen1 1 will Display the Watch 1 window
CTRL+Alt+Wthen2 2 will Display the Watch 2 window
CTRL+Alt+Wthen3 3 will Display the Watch 3 window
CTRL+Alt+Wthen4 4 will Display the Watch 4 window
CTRL+Alt+VthenA A will Display the Autos window
CTRL+Alt+VthenL L will Display the Locals window
CTRL+Alt+I Used to Display the Immediate window
CTRL+Alt+C It is Used to Display the Call Stack window
CTRL+Alt+H This Shortcut is Used to Display the Threads window
CTRL+Shift+DthenS S will Display the Parallel Stacks window
CTRL+Shift+DthenK K will Display the Parallel Tasks window

Microsoft IntelliSense Shortcuts:

Shortcut Function
CTRL+J Used to List members
CTRL+SpaceorAlt+ It is Used to Complete word
CTRL+K then CTRL+i This Shortcut will Display quick information
CTRL+Shift+Space Used to Display parameter information
CTRL+Shift+Alt+C It is Used to Copy parameter tip
CTRL+Shift+Alt+P Used to Paste parameter tip
CTRL+] This Shortcut will Jump between syntax pairs
CTRL+K then CTRL+X Used to Launch code snippet picker
CTRL+Shift+R Used to Refresh local cache
CTRL+K then CTRL+S It is Used to Launch Surround With snippet picker
CTRL+K then CTRL+B Used to Display the Code Snippet Manager
Alt++ It Changes the IntelliSense filter level from the Common tab to the All tab
Alt+. It will Change the IntelliSense filter level from the All tab to the Common tab

Document window and Browser Shortcuts:

Shortcut Function
Shift+Alt+Enter Used to Toggle full-screen mode
F6 It is Used to Move to the next pane of a split-pane view of a document
CTRL+Shift+F6orCTRL+Shift+Tab Used to Move to the previous document in the editor or designer
Shift+F6 It is Used to Move to the previous page of a document in a split-pane view
Alt+ Used to display the previous page in the viewing history (back)
Alt+ It will display the next page in the viewing history (Forward)
Esc This Shortcut Closes a menu or dialog box, cancels an operation in progress, or places focus in the current window

Solution Explorer Shortcuts:

Shortcut Function
CTRL+Alt+L Used to Display Solution Explorer
CTRL+N It will Display the New File dialog box to create a new file
CTRL+Shift+N Used to display the New Project dialog box to create a new project
CTRL+O It is Used to Display the Open File dialog box to open an existing file
F2 It will Change the name of the selected object

Help and Books Online Shortcuts:

Shortcut Function
F1orShift+F1 Help
CTRL+F1 It will Display SQL Server Books Online
CTRL+Alt+F1 Helps to Open the Help Library Manager
CTRL+Alt+F2 Used to Display the SQL Server Resource Center Web page
Shift+F1 It is Used to Display help for the current editor window

Search Shortcuts:

Shortcut Function
CTRL+F It will display the Find dialog box
F12 It Displays the definition for the selected symbol
Shift+F12 This Shortcut Displays the list of references for the selected symbol
CTRL+H Used to Display the Replace dialog box
CTRL+I Used to Start the incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search
F3 Used to Find the next occurrence of the previous search text
Shift+F3 It will find the previous occurrence of the search text
CTRL+F3 It is Used to Find the next occurrence of the currently selected text
CTRL+Shift+F3 Helps to Find the previous occurrence of the currently selected text
CTRL+Shift+H Used to Display the Replace in Files dialog box
CTRL+Shift+I Used to Reverse incremental search so it starts at the bottom of the file and searches to the top
Alt+F3thenB B will Select or clear the Search up option in Find and Replace
Alt+F3thenS S will Stop the Find in Files search
Alt+F3thenW W will Select or clear the Find whole word option in Find and Replace
Alt+F3thenP Used to Select or clears the Wildcard option in Find and Replace
CTRL+/ It is Used to Place the caret in the Find or Command box of the Standard toolbar

Cut and Paste Shortcuts:

Shortcut Function
CTRL+XorShift+Del Used to Cut. It will delete the currently selected item and place it to the Clipboard.
CTRL+LorCTRL+Shift+L Used to Cuts all of the selected lines, or the current line if nothing is selected
CTRL+CorCTRL+Insert It is Used to Copy to the Clipboard
CTRL+VorShift+Insert Used to Paste from the Clipboard at the insertion point
CTRL+Shift+VorCTRL+Shift+Insert Used to Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item

Activity Monitor Shortcuts:

Shortcut Function
CTRL+Alt+A It will Launch Activity Monitor
CTRL+F4 It Closes Activity Monitor
F5 Refresh
CTRL+Shift+F Used to Filter the monitor display
F6 Used to Cycle through panels
CTRL++orCTRL+ This Shortcut is Used to Expand or collapse the selected pane
+or Helps to Expand or collapse all panes
CTRL+C It will Copy the entire selected row in the grid
CTRL+Shift+C Used to Copy the cell
Alt+ Used to Drop-down for filtering in grid
CTRL+Alt+↑↓ Used to Scroll up or down Activity Monitor

Replication Monitor:

Shortcut Function
F5 Refresh
Enter It is Used to Open a detail window from a grid

Replication Conflict Viewer Shortcuts:

Shortcut Function
F6 Used to Define filter
F7 It will Apply filter
F8 Used to show all columns

Query Designer Shortcuts:

Shortcut Function
CTRL+T Used to Cancel or stop the currently running query
CTRL+1 This Shortcut Displays the diagram pane of the Query Designer
CTRL+2 It Displays the criteria pane of the Query Designer
CTRL+3 Used to Display the SQL pane of the Query Designer
CTRL+4 It is Used to Display the results pane of the Query Designer
CTRL+R Used to Run the query specified in the Query Designer
CTRL+G Use this Shortcut, When in the results pane, moves focus to the tool strip docked at the bottom of the designer
CTRL+Shift+J It Enables JOIN mode in the Query Designer

Designer Shortcuts:

Shortcut Function
Used to move the selected control down in increments of 8 on the design surface
It is Used to Move the selected control left in increments of 8 on the design surface
Used to Move the selected control right in increments of 8 on the design surface
It is Used to Move the selected control up in increments of 8 on the design surface
Shift+ This Shortcut Increases the height of the selected control in increments of 8
Shift+ It Reduces the width of the selected control in increments of 8
Shift+ This Shortcut key Increases the width of the selected control in increments of 8
Shift+ This will decrease the height of the selected control in increments of 8
Tab It Moves to the next control on the page
Shift+Tab It is Used to Move to the previous control on the page
Enter Used to display the grid on the design surface

In this article, you can understand all the shortcuts for SQL Server Management Studio (SSMS). If it is useful to you, then leave your feedback in the comment section.

Leave a Comment