SQL Server Management Studio (SSMS) keyboard shortcuts 

SQL Server Management Studio (SSMS)    

Zeynel -
7 years ago
- Shortcuts
0
Ctrl + End

Move the cursor to the end of the document

0
↑  Shift +

Select text down line by line starting from the cursor

0
↑  Shift +

Increases the height of the selected control in increments of 8

0
Alt + F4

Exit

0
or Alt + F4
0
Ctrl + F4

Close the current MDI child window

0
Ctrl + F4

Close

0
Ctrl + F4

Closes Activity Monitor

0
Ctrl + ↑  Shift + O

Display the Open Project dialog box to open an existing project

0
Alt +

Drop-down for filtering in grid

0
Ctrl + ↑  Shift + U

Make the selected text upper case

1
Ctrl + ↑  Shift + U

Change the selected text to uppercase

0
↑  Shift + F3

Find the previous occurrence of the search text

0
Ctrl + /

Place the caret in the Find/Command box of the Standard toolbar

0
Ctrl + ↑  Shift + Tab

Cycle through the previous MDI child windows

0
Ctrl + ↑  Shift + Tab

Move to the previous document in the editor or designer

0
Ctrl + Del

Delete the word to the right of the cursor

0
Ctrl + ]

Jump between syntax pairs

0
Ctrl + ↑  Shift + H

Display the Replace in Files dialog box

0
Ctrl + 5

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
Ctrl + ↑  Shift + W

Open the current file in a browser

‎−1
↑  Shift + Del

Cut (delete the currently selected item and place it to the Clipboard)

0
Ctrl + Page Down

Moves the cursor to the bottom of the document

0
Ctrl + Page Down

Moves to the next tab in the document

0
Ctrl + Page Up

Moves the cursor to the top of the document

0
Ctrl + Page Up

Moves to the previous tab in the document

0
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.

0
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

0
Ctrl + 6

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
Ctrl + Backspace

Delete the word to the left of the cursor

0
↑  Shift + F5

Stop debugging

1
↑  Shift + F10

Display the context menu

0
Ctrl + ↑  Shift +

Extend the selection one word to the right

0
Ctrl + ↑  Shift +

Extend the selection one word to the left

0
Ctrl + Alt + C

Display the Call Stack window

1
Ctrl + F6

Cycle through the next MDI child windows

0
Ctrl + 8

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
or Ctrl + 9
0
↑  Shift + F6

Move to the previous pane of a document in split pane view

1
↑  Shift + F6

(in the Database Engine Query Editor) Move to the next pane of a split pane view of a single document

0
↑  Shift + F6

Move to the previous pane of a split pane view of a single document

0
Ctrl + F5

Parse the selected portion of the query editor or the entire query editor if nothing is selected

0
Ctrl + 7

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

0
or Ctrl + 7
0
Ctrl + F3

Find the next occurrence of the currently selected text

1
Ctrl + Alt + T

Display Template Explorer

‎−1
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

0
Ctrl + Alt + R

Display the Browser Window

0
Ctrl + Insert

Copy to the Clipboard

0
↑  Shift + End

Select text from the cursor to the end of the current line

0
↑  Shift + Insert

Paste from the Clipboard at the insertion point

0
Ctrl + F1

Display SQL Server Books Online

0
↑  Shift + F1

Help

0
↑  Shift + F1

Display help for the current editor window

1
↑  Shift + Home

Select text from the cursor to the start of the current line

0
Ctrl + Alt + L

Display Solution Explorer

0
or Ctrl + Alt + L
0
Ctrl + Alt + P

Open SQL Server Profiler

0
Ctrl + =

Select the current location in the editor, back to the previous location in the editor

Advertisement

0
Ctrl + =

Select the text from the current location of the cursor to the Navigate Backward (Ctrl + -) location

0
Ctrl + F9

Enable breakpoint

0
Ctrl + ↑  Shift + J

Enables JOIN mode in the Query Designer

1
Ctrl + ↑  Shift + ⤶ Enter

Insert a blank line below the cursor

0
↑  Shift + F11

Step out

0
↑  Shift + F8

Returns the cursor to the last item

0
↑  Shift + F9

Display the QuickWatch dialog box

0
Ctrl + Alt + I

Display the Immediate window

0
↑  Shift + F12

Displays the list of references for the selected symbol

0
Shift + Page Up

Extend selection up one page

0
Shift + Page Down

Extend selection down one page

0
Ctrl + \

then T: Display the Task List window

1
Ctrl + \

then Ctrl + T: Display the Task List window

0
Ctrl + \

then Ctrl + E  Display the Error List Window (Transact-SQL Editor only)

0
Ctrl + \

E Display a smart tag menu of common commands for Web server controls in the HTML designer

0
Ctrl + \

then E   Display the Error List Window (Transact-SQL Editor only)

0
Ctrl + Alt + B

Display the Breakpoints window

0
Ctrl + Alt +

Display a popup listing all open windows

0
Ctrl + ↑  Shift + Q

Display the Query Designer dialog from the query editor window

‎−1
Ctrl + ↑  Shift + Q

Display the Query Designer

1
Ctrl + ↑  Shift + Home

Select text from the cursor to the beginning of the document

1
Ctrl + ↑  Shift + End

Select text from the cursor to the end of the document

0
Ctrl + ↑  Shift + Space

Display parameter information

0
Ctrl + Alt + G

Display Registered Servers

0
Alt + F1

Run the sp_help system stored procedure

0
Ctrl + F10

Implement the Run To Cursor command

0
Ctrl + Alt + O

Display the Output window

0
Alt + F8

Open database in Object Explorer

0
↑  Shift + Alt +

Moves the cursor one character to the right and extends the column selection

0
↑  Shift + Alt +

Move the cursor up one line, extending the selection

0
↑  Shift + Alt +

Moves the cursor one character to the left and extends the column selection

0
↑  Shift + Esc

Close the current tool window

0
Ctrl + ↑  Shift + -

Go forward to the next document or window in the navigation history

0
Alt + Backspace

Reverse the last editing action

0
↑  Shift + Ctrl + Del

Moves the cursor down one line, extending the column selection

0
Ctrl + ↑  Shift + Del

Delete all text in the current file

0
Alt + F7

Display the IDE navigator with the first tool window selected

0
*

(on the numeric keypad) Expand all tree nodes

0
↑  Shift + Backspace

Delete one character to the left of the cursor

0
↑  Shift + Alt + T

Moves the line containing the cursor below the next line

0
Ctrl + ↑  Shift + ]

Move the cursor to the next brace, extending the selection

0
Ctrl + Alt + H

Display the Threads window

0
Alt + .

Changes the IntelliSense filter level from the All tab to the Common tab

0
Alt + -

Display the dock menu

0
Alt + F5

Start or continue debugging

0
↑  Shift + Alt + A

Display the Add Existing Item dialog box to add an existing file to the current project

0
Ctrl + Shift + Page Up

Extend the selection to the top of the current window

0
Ctrl + Shift + Page Up

Moves the cursor to the first line in view, extending the selection

0
Ctrl + Shift + Page Down

Moves the cursor to the last line in view, extending the selection

0
Ctrl + Shift + Page Down

Move the cursor to the last line in view, extending the selection

0
Ctrl + ↑  Shift + F3

Find the previous occurrence of the currently selected text

0
Ctrl + Alt + X

Display the Toolbox

0
Ctrl + ↑  Shift + F6

Move to the previous document in the editor or designer

0
Alt + F6

Move to the next active window in Management Studio

0
Alt + F6

Move to the next tool window

0
Ctrl + ↑  Shift + F9

Delete all breakpoints

0
Ctrl + Alt + Q

Display the QuickWatch dialog box

0
Ctrl + ↑  Shift + Alt + C

Copy parameter tip

0
Ctrl + ↑  Shift + Alt + R

Show the query results pane

0
Ctrl + ↑  Shift + F12

Move to the next entry in the Error List window (Transact-SQL Editor only)

0
Alt + +

Changes the IntelliSense filter level from the Common tab to the All tab

‎−1
Alt + +

Activate the menu for a tool component

0
Ctrl + ↑  Shift + Insert

Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item

0
Ctrl + ↑  Shift + Alt + P

Paste parameter tip

0
Ctrl + ↑  Shift + Alt +

Move the cursor to the right one word, extending the selection

0
Ctrl + ↑  Shift + Alt +

Move the cursor to the left one word, extending the selection

0
↑  Shift + Alt

Move to the current tool window toolbar

0
Ctrl + ↑  Shift + Alt + L

Display the estimated execution plan

0
Ctrl + ↑  Shift + Alt + M

Include actual execution plan in the query output

0
Ctrl + Alt +   

Scroll up or down Activity Monitor

0
↑  Shift + Alt + ⤶ Enter

Toggle full screen mode

0
↑  Shift + Alt + ⤶ Enter

Toggle the full-screen display

0
↑  Shift + Alt + ⤶ Enter

Toggle full-screen mode

1
↑  Shift + Alt + F10

Display a smart tag menu of common commands for Web server controls in the HTML designer

0
↑  Shift + Alt + F11

Step into specific statement

0
Ctrl + Alt + F1

Open the Help Library Manager

0
↑  Shift + Alt + Home

Moves the cursor to the start of the current line and extends the column selection

0
Alt + ↑  Shift + Backspace

Restore the previously undone edit

0
Ctrl + Alt + F2

Display the SQL Server Resource Center Web page

0
↑  Shift + Alt + End

Moves the cursor to the end of the line, extending the column selection

1
↑  Shift + Alt + F6

Move to the previously selected window

0
Ctrl + K then Ctrl + U

Remove the comment syntax from the current line

0
↑  Shift + Alt + F7

Move to the previous tool window

0
Ctrl + Alt + Break

Break all

0
Ctrl + K then Ctrl + X

Launch code snippet picker

0
Ctrl + K then Ctrl + I

Display quick information

0
Ctrl + K then Ctrl + B

Display the Code Snippet Manager

0
Ctrl + K then Ctrl + S

Launch Surround With snippet picker

0
Ctrl + K then Ctrl + F

Correctly indents the selected lines of code based on the surrounding lines of code

0
Ctrl + M then Ctrl + S

Collapses the currently selected outlining region

0
Ctrl + M then Ctrl + M

Toggles the currently selected hidden text section between the hidden and display states


Share this page on:
Is this page helpful?
0 0

What is your favorite SQL Server Management Studio (SSMS) hotkey? Do you have any useful tips for it? Let other users know below.


Only registered users can post links.
 
No comments yet. Ask, or type the first one!

Latest articles