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).
Last Updated On Aug 3, 2020.
Download SQL Server Management Studio (SSMS) Shortcuts for Offline Study Here: SQL Server Management Studio (SSMS) Shortcuts.PDF
Menu Activation Shortcuts:
| 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 | |
| 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.