Show all columns

`F8`

All hotkeys for SQL Server Management Studio (SSMS)

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