SQL Server Management Studio (SSMS)

Code editor

Display the estimated execution plan

Ctrl + ↑   Shift + Alt + L

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

Similar combinations for other applications