====================================================== SQL Server Management Studio (SSMS) keyboard shortcuts ====================================================== First published at 12/18/2017 on https://defkey.com/sql-server-management-studio-shortcuts SQL Server Management Studio (SMSS) is an integrated environment for managing any SQL infrastructure. It allows you to manage, configure and develop components of SQL Server, Azure SQL Database, and SQL Data Warehouse. SQL Server Management Studio (SSMS) has 328 shortcuts and we have listed all of them below. Menu activation --------------- Alt Move to the SQL Server Management Studio menu bar Alt + + Activate the menu for a tool component Shift + F10 Display the context menu Ctrl + N Display the New File dialog box to create a file Ctrl + Shift + N Display the New Project dialog box to create a new project Ctrl + O Display the Open File dialog box to open an existing file Ctrl + Shift + G Display the Open File dialog box to open an existing file Ctrl + Shift + O Display the Open Project dialog box to open an existing project Ctrl + Shift + A Display the Add New Item dialog box to add a new file to the current project Shift + Alt + A Display the Add Existing Item dialog box to add an existing file to the current project Ctrl + Shift + Q Display the Query Designer Esc Close a menu or dialog box, canceling the action Windows management ------------------ Ctrl + F4 Close the current MDI child window Esc Close a menu or dialog box, cancels an operation in progress, or focuses on the current document window Ctrl + P Print Alt + F4 Exit Shift + Alt + Enter Toggle full screen mode Shift + Esc Close the current tool window Ctrl + F6 Cycle through the next MDI child windows Ctrl + Tab Display the IDE navigator with the first document window selected Ctrl + Shift + Tab Cycle through the previous MDI child windows Ctrl + F2 Moves 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 Move to the current tool window toolbar Alt + F7 Display the IDE navigator with the first tool window selected Alt + F6 Move to the next tool window F6 (in the Database Engine Query Editor)  Move to the next tool window Shift + Alt + F7 Move to the previous tool window F6 Move to the next pane of a split pane view of a single document Shift + Alt + F6 Move to the previously selected window Shift + F6 (in the Database Engine Query Editor) Move to the next pane of a split pane view of a single document Shift + F6 Move to the previous pane of a split pane view of a single document Alt + - Display the dock menu Ctrl + Alt + Down arrow Display a popup listing all open windows Ctrl + O Opens a new query editor window F8 Display Object Explorer Ctrl + Alt + G Display Registered Servers Ctrl + Alt + T Display Template Explorer Ctrl + Alt + L Display Solution Explorer F7 Display the Summary Window F4 Display the Properties Window Ctrl + Alt + O Display the Output window Ctrl + \ then T: Display the Task List window Ctrl + \ then Ctrl + T: Display the Task List window F6 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 Display the Toolbox Ctrl + K then Ctrl + W: Display the Bookmarks Window Ctrl + Alt + R Display the Browser Window Shift + Alt + F10 Display a smart tag menu of common commands for Web server controls in the HTML designer Ctrl + \ then Ctrl + E  Display the Error List Window (Transact-SQL Editor only) Ctrl + \ E Display a smart tag menu of common commands for Web server controls in the HTML designer Ctrl + \ then E   Display the Error List Window (Transact-SQL Editor only) Ctrl + Shift + F12 Move to the next entry in the Error List window (Transact-SQL Editor only) Alt + Left arrow Display the previous page in the viewing history. Available only in the Web browser window Alt + Right arrow Display the next page in the viewing history. Available only in the Web browser window Cursor movement --------------- Left arrow Move the cursor left Right arrow Move the cursor right Up arrow Move the cursor up Down arrow Move the cursor down Home Move the cursor to the beginning of the line End Move the cursor to the end of the line Ctrl + Home Move the cursor to the beginning of the document Ctrl + End Move the cursor to the end of the document Page Up Move the cursor up one screen Page Down Move the cursor down one screen Ctrl + Right arrow Moves the cursor one word to the right Ctrl + Left arrow Moves the cursor one word to the left Shift + F8 Returns the cursor to the last item Ctrl + Page Up Moves the cursor to the top of the document Ctrl + Page Up Moves to the previous tab in the document Ctrl + Page Down Moves the cursor to the bottom of the document Ctrl + Page Down Moves to the next tab in the document Text selection -------------- Ctrl + Shift + Home Select text from the cursor to the beginning of the document Ctrl + Shift + End Select text from the cursor to the end of the document Shift + Home Select text from the cursor to the start of the current line Shift + Alt + Home Moves the cursor to the start of the current line and extends the column selection Shift + End Select text from the cursor to the end of the current line Shift + Alt + End Moves the cursor to the end of the line, extending the column selection Shift + Down arrow Select text down line by line starting from the cursor Note: I'm not sure if below shortcut is correct. It's listed in Microsoft's documents. Please let me know in comments if you know the correct one. Shift + Ctrl + Del Moves the cursor down one line, extending the column selection Shift + Left arrow Moves the cursor one character to the left and extends the selection Shift + Alt + Left arrow Moves the cursor one character to the left and extends the column selection Shift + Right arrow Moves the cursor one character to the right and extends the selection Shift + Alt + Right arrow Moves the cursor one character to the right and extends the column selection Shift + Up arrow Select text up line by line starting from the cursor Shift + Alt + Up arrow Move the cursor up one line, extending the selection Shift + Page Up Extend selection up one page Shift + Page Down Extend selection down one page Ctrl + A Select the entire current document Ctrl + W Select the word containing the cursor, or the closest word Ctrl + = Select the current location in the editor, back to the previous location in the editor Ctrl + Shift + Page Up Extend the selection to the top of the current window Ctrl + Shift + Page Down Move the cursor to the last line in view, extending the selection Ctrl + Shift + Right arrow Extend the selection one word to the right Ctrl + Shift + Left arrow Extend the selection one word to the left Ctrl + Shift + Alt + Right arrow Move the cursor to the right one word, extending the selection Ctrl + Shift + Alt + Left arrow Move the cursor to the left one word, extending the selection Ctrl + Shift + ] Move the cursor to the next brace, extending the selection Ctrl + = Select the text from the current location of the cursor to the Navigate Backward (Ctrl + -) location Ctrl + - Go back to the previous document or window in the navigation history Ctrl + Shift + - Go forward to the next document or window in the navigation history Ctrl + K then Ctrl + A: Swaps the anchor and end points of the current selection Ctrl + Shift + Page Up Moves the cursor to the first line in view, extending the selection Ctrl + Shift + Page Down Moves the cursor to the last line in view, extending the selection Bookmark -------- Ctrl + K then Ctrl + K: Set or remove a bookmark at the current line Ctrl + K then Ctrl + N  Next bookmark Ctrl + Shift + K then Ctrl + Shift + N: If 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 folder, bookmarks in folders are skipped Ctrl + K then Ctrl + P:  Previous bookmark Ctrl + Shift + K then Ctrl + Shift + P:  If 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 folder, bookmarks in folders are skipped. Ctrl + K then Ctrl + L: Clear bookmarks Tree kontrol ------------ - (on the numeric keypad) Collapse tree nodes * (on the numeric keypad) Expand all tree nodes Ctrl + Up arrow Scroll the tree control up in the window Ctrl + Down arrow Scroll the tree control down in the window Code editor ----------- Shift + Alt + Enter Toggle the full-screen display Ctrl + Up arrow Scroll text up one line Ctrl + Down arrow Scroll text down one line Ctrl + Z Reverse the last editing action Alt + Backspace Reverse the last editing action Ctrl + Shift + Z Restore the previously undone edit Ctrl + Y Restore the previously undone edit Alt + Shift + Backspace Restore the previously undone edit Ctrl + S Save the selected item Ctrl + Shift + S Save all Ctrl + F4 Close Ctrl + P Print Alt + F4 Exit Ctrl + Shift + W Open the current file in a browser Ctrl + Shift + Del Delete all text in the current file Ctrl + G Display the Go To Line dialog box Ctrl + + Display the Navigate To dialog box. Tab Increase line indent Shift + Tab Decrease line indent Ctrl + Shift + U Make the selected text upper case Ctrl + U Make the selected text lower case Ctrl + K then Ctrl + C:  Make the selected text a comment Ctrl + K then Ctrl + U:  Uncomment the selected text Ctrl + N Open a new query with current connection Alt + F8 Open database in Object Explorer Ctrl + Shift + M Specify values for template parameters F5 Run the selected portion of the query editor or the entire query editor if nothing is selected Ctrl + Shift + E Run the selected portion of the query editor or the entire query editor if nothing is selected Ctrl + F5 Parse the selected portion of the query editor or the entire query editor if nothing is selected Ctrl + Shift + Alt + L Display the estimated execution plan Alt + Break Cancel the executing query Ctrl + Shift + Alt + M Include actual execution plan in the query output Ctrl + Shift + D Output results in a grid Ctrl + T Output results in text format Ctrl + Shift + T Output results to a file Ctrl + R Show or hide the query results pane Ctrl + Shift + Alt + R Show the query results pane F6 Toggle between query and results pane Ctrl + Shift + C Copy the result grid and headers to the clipboard Alt + F6 Move to the next active window in Management Studio Ctrl + Alt + P Open SQL Server Profiler Ctrl + Shift + Q Display the Query Designer dialog from the query editor window Alt + F1 Run the sp_help system stored procedure Ctrl + 1 Run the sp_who system stored procedure Ctrl + 2 Run the sp_lock system stored procedure Ctrl + 3 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Ctrl + 4 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Ctrl + 5 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Ctrl + 6 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Ctrl + 7 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Ctrl + 7 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Ctrl + 8 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Ctrl + 9 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Ctrl + 0 Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog Text manipulation in code editor -------------------------------- Enter Insert a new line Shift + Enter Insert a new line Ctrl + T Swap the characters on either side of the cursor (Does not apply to the SQL Editor) Del Delete one character to the right of the cursor Backspace Delete one character to the left of the cursor Shift + Backspace Delete one character to the left of the cursor Ctrl + K then C: Delete whitespace in the selection, or deletes whitespace adjacent to the cursor if there is no selection Tab Insert the number of spaces configured for the editor Ctrl + Enter Insert a blank line above the cursor Ctrl + Shift + Enter Insert a blank line below the cursor Ctrl + Shift + L Change the selected text to lowercase Ctrl + Shift + U Change the selected text to uppercase Insert Toggle between insert mode and overtype mode Shift + Tab Move selected lines to the left on tab stop Ctrl + Del Delete the word to the right of the cursor Ctrl + Backspace Delete the word to the left of the cursor Ctrl + Shift + T Transpose the words on either side of the cursor (Does not apply to the SQL Editor) Shift + Alt + T Moves the line containing the cursor below the next line Ctrl + K then Ctrl + D: 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 + K then Ctrl + F Correctly indents the selected lines of code based on the surrounding lines of code Ctrl + K then Ctrl + H Set or remove a shortcut in the current line Ctrl + K then Ctrl + U Remove the comment syntax from the current line Ctrl + R then Ctrl + W Shows or hides spaces and tabs Alt + F then Ctrl + W Enables or disables word wrap in an editor Ctrl + M then Ctrl + A Collapses all outlining regions to show just the outermost groups in the hierarchy Ctrl + M then Ctrl + S Collapses the currently selected outlining region Ctrl + M then Ctrl + X Expands all outlining regions on the page Ctrl + M then Ctrl + E Expands the currently selected outlining region Ctrl + M then Ctrl + O Collapses existing outlining regions Ctrl + M then Ctrl + H Hides the selected text. A signal icon marks the location of the hidden text Ctrl + M then Ctrl + L Toggles all text sections previously marked as hidden between the hidden and display states Ctrl + M then Ctrl + M Toggles the currently selected hidden text section between the hidden and display states Ctrl + M then Ctrl + P Removes all outlining information in the document Ctrl + M then Ctrl + U Removes the outlining information for the currently selected region Transact-SQL debugger --------------------- Alt + F5 Start or continue debugging Shift + F5 Stop debugging F11 Step into F10 Step over Shift + F11 Step out Shift + Alt + F11 Step into specific statement Ctrl + 3 Set next statement Alt + Num Lock Show next statement Ctrl + F10 Implement the Run To Cursor command Ctrl + Alt + Q Display the QuickWatch dialog box Shift + F9 Display the QuickWatch dialog box F9 Toggle breakpoint Ctrl + F9 Enable breakpoint Alt + F9 then D D Delete the breakpoint. Only available in the Breakpoints window Alt + F9 then L L Open the Edit breakpoint labels dialog. Only available in the Breakpoints window Ctrl + Shift + F9 Delete all breakpoints Ctrl + Alt + B Display the Breakpoints window Ctrl + Alt + Break Break all Ctrl + B Break at function Ctrl + Alt + W then 1 Display the Watch 1 window Ctrl + Alt + W then 2 Display the Watch 2 window Ctrl + Alt + W then 3 Display the Watch 3 window Ctrl + Alt + W then 4 Display the Watch 4 window Ctrl + Alt + V then A Display the Autos window Ctrl + Alt + V then L Display the Locals window Ctrl + Alt + I Display the Immediate window Ctrl + Alt + C Display the Call Stack window Ctrl + Alt + H Display the Threads window Ctrl + Shift + D then S Display the Parallel Stacks window Ctrl + Shift + D then K Display the Parallel Tasks window Microsoft IntelliSense ---------------------- Ctrl + J List members Ctrl + Space Complete word Alt + Right arrow Complete word Ctrl + K then Ctrl + I Display quick information Ctrl + Shift + Space Display parameter information Ctrl + Shift + Alt + C Copy parameter tip Ctrl + Shift + Alt + P Paste parameter tip Ctrl + ] Jump between syntax pairs Ctrl + K then Ctrl + X Launch code snippet picker Ctrl + Shift + R Refresh local cache Ctrl + K then Ctrl + S Launch Surround With snippet picker Ctrl + K then Ctrl + B Display the Code Snippet Manager Alt + + Changes the IntelliSense filter level from the Common tab to the All tab Alt + . Changes the IntelliSense filter level from the All tab to the Common tab Document window and browser --------------------------- Shift + Alt + Enter Toggle full-screen mode F6 Move to the next pane of a split pane view of a document Ctrl + Shift + F6 Move to the previous document in the editor or designer Ctrl + Shift + Tab Move to the previous document in the editor or designer Shift + F6 Move to the previous pane of a document in split pane view Alt + Left arrow Back, display the previous page in the viewing history Alt + Right arrow Forward, display the next page in the viewing history Esc Closes a menu or dialog box, cancels an operation in progress, or places focus in the current window Solution Explorer ----------------- Ctrl + Alt + L Display Solution Explorer Ctrl + N Display the New File dialog box to create a new file Ctrl + Shift + N Display the New Project dialog box to create a new project Ctrl + O Display the Open File dialog box to open an existing file F2 Change the name of the selected object Help and Books Online --------------------- F1 Help Shift + F1 Help Ctrl + F1 Display SQL Server Books Online Ctrl + Alt + F1 Open the Help Library Manager Ctrl + Alt + F2 Display the SQL Server Resource Center Web page Shift + F1 Display help for the current editor window Search ------ Ctrl + F Display the Find dialog box F12 Displays the definition for the selected symbol Shift + F12 Displays the list of references for the selected symbol Ctrl + H Display the Replace dialog box Ctrl + I Start incremental search. Type the characters to search for or press Ctrl + I to search for characters from the previous search F3 Find the next occurrence of the previous search text Shift + F3 Find the previous occurrence of the search text Ctrl + F3 Find the next occurrence of the currently selected text Ctrl + Shift + F3 Find the previous occurrence of the currently selected text Ctrl + Shift + H Display the Replace in Files dialog box Ctrl + Shift + I Reverse incremental search so it starts at the bottom of the file and searches to the top Alt + F3 then B Select or clear the Search up option in Find and Replace Alt + F3 then S Stop the Find in Files search Alt + F3 then W Select or clear the Find whole word option in Find and Replace Alt + F3 then P Select or clears the Wildcard option in Find and Replace Ctrl + / Place the caret in the Find/Command box of the Standard toolbar Cut and paste ------------- Ctrl + X Cut (delete the currently selected item and place it to the Clipboard) Shift + Del Cut (delete the currently selected item and place it to the Clipboard) Ctrl + L Cuts all of the selected lines, or the current line if nothing is selected Ctrl + Shift + L Cuts all of the selected lines, or the current line if nothing is selected Ctrl + C Copy to the Clipboard Ctrl + Insert Copy to the Clipboard Ctrl + V Paste from the Clipboard at the insertion point Shift + Insert Paste from the Clipboard at the insertion point Ctrl + Shift + V Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item Ctrl + Shift + Insert Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item Activity Monitor ---------------- CTRLl + Alt + A Launches Activity Monitor Ctrl + F4 Closes Activity Monitor F5 Refresh Ctrl + Shift + F Filter the monitor display F6 Cycle through panels Ctrl + + Expand or collapse selected pane Ctrl + - Expand or collapse selected pane + Expand or collapse all panes - Expand or collapse all panes Ctrl + C Copies entire selected row in grid Ctrl + Shift + C Copy cell Alt + Down arrow Drop-down for filtering in grid Ctrl + Alt + Up arrow / Down arrow Scroll up or down Activity Monitor Replication Monitor ------------------- F5 Refresh Enter Open a detail window from a grid Replication Conflict Viewer --------------------------- F6 Define filter F7 Apply filter F8 Show all columns Query Designer -------------- Ctrl + T Cancels or stops the currently running query Ctrl + 1 Displays the diagram pane of the Query Designer Ctrl + 2 Displays the criteria pane of the Query Designer Ctrl + 3 Displays the SQL pane of the Query Designer Ctrl + 4 Displays the results pane of the Query Designer Ctrl + R Run the query specified in the Query Designer Ctrl + G When in the results pane, moves focus to the tool strip docked at the bottom of the designer Ctrl + Shift + J Enables JOIN mode in the Query Designer Designer -------- Down arrow Move the selected control down in increments of 8 on the design surface Left arrow Move the selected control left in increments of 8 on the design surface Right arrow Move the selected control right in increments of 8 on the design surface Up arrow Move the selected control up in increments of 8 on the design surface Shift + Down arrow Increases the height of the selected control in increments of 8 Shift + Left arrow Reduces the width of the selected control in increments of 8 Shift + Right arrow Increases the width of the selected control in increments of 8 Shift + Up arrow Decreases the height of the selected control in increments of 8 Tab Moves to the next control on the page Shift + Tab Moves to the previous control on the page Enter Display the grid on the design surface Last modified on(UTC): Sunday, September 6, 2020 Defkey © All rights reserved.