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
|