Hotkeys and shortcuts for SQL Server Management Studio (SSMS)

(Total 240)

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