SQL Server Management Studio (SSMS) keyboard shortcuts 

SQL Server Management Studio (SSMS)    

Zeynel -
7 years ago
- Shortcuts
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

1
Ctrl + ↑  Shift + ⤶ Enter

Insert a blank line below the cursor

0
Ctrl + ↑  Shift + J

Enables JOIN mode in the Query Designer

0
Ctrl + Alt + P

Open SQL Server Profiler

0
Ctrl + +

Display the Navigate To dialog box.

0
Ctrl + +

Expand or collapse selected pane

0
or Ctrl + -
‎−1
Ctrl + -

Go back to the previous document or window in the navigation history

0
Ctrl + ↑  Shift + Insert

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

0
Ctrl + 0

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

0
Ctrl + ↑  Shift + V

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

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

1
Ctrl + ↑  Shift + G

Display the Open File dialog box to open an existing file

0
Ctrl + K

then Ctrl + W: Display the Bookmarks Window

0
Ctrl + K

then Ctrl + L: Clear bookmarks

0
Ctrl + K

then Ctrl + K: Set or remove a bookmark at the current line

0
Ctrl + K

then Ctrl + N  Next bookmark

0
Ctrl + K

then Ctrl + A: Swaps the anchor and end points of the current selection

0
Ctrl + K

then Ctrl + P:  Previous bookmark

0
Ctrl + K

then Ctrl + C:  Make the selected text a comment

‎−1
Ctrl + K

then Ctrl + U:  Uncomment the selected text

0
Ctrl + K

then C: Delete whitespace in the selection, or deletes whitespace adjacent to the cursor if there is no selection

0
Ctrl + K

then Ctrl + D: 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

0
Ctrl +

Scroll text up one line

0
Ctrl +

Scroll the tree control up in the window

0
Ctrl +

Scroll the tree control down in the window

0
Ctrl +

Scroll text down one line

0
Ctrl + F5

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

0
Ctrl + ↑  Shift + R

Refresh local cache

0
Ctrl + Alt + G

Display Registered Servers

0
Ctrl + ⤶ Enter

Insert a blank line above the cursor

0
↑  Shift + ⤶ Enter

Insert a new line

0
Ctrl + ↑  Shift + H

Display the Replace in Files dialog box

0
Ctrl + ↑  Shift + D

Output results in a grid

0
Ctrl +

Moves the cursor one word to the left

0
Ctrl +

Moves the cursor one word to the right

0
+

Expand or collapse all panes

0
or -
0
-

(on the numeric keypad) Collapse tree nodes

0
Ctrl + Home

Move the cursor to the beginning of the document

0
Ctrl + End

Move the cursor to the end of 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 + T

Transpose the words on either side of the cursor (Does not apply to the SQL Editor)

0
Ctrl + ↑  Shift + T

Output results to a file

0
Ctrl + ↑  Shift + N

Display the New Project dialog box to create a new project

‎−1
or Ctrl + ↑  Shift + N
0
Ctrl + ↑  Shift + C

Copy the result grid and headers to the clipboard

0
Ctrl + ↑  Shift + C

Copy cell

0
Ctrl + ↑  Shift + S

Save all

0
↑  Shift + F5

Stop debugging

0
Ctrl + ↑  Shift + Q

Display the Query Designer dialog from the query editor window

‎−1
Ctrl + ↑  Shift + Q

Display the Query Designer

0
Ctrl + ↑  Shift + M

Specify values for template parameters

Advertisement

0
Ctrl + U

Make the selected text lower case

0
Ctrl + J

List members

0
Ctrl + ↑  Shift + A

Display the Add New Item dialog box to add a new file to the current project

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 + 9

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

0
Ctrl + ↑  Shift + Z

Restore the previously undone edit

0
Alt + F7

Display the IDE navigator with the first tool window selected

0
Ctrl + =

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

0
Ctrl + =

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

0
Ctrl + Del

Delete the word to the right of the cursor

1
↑  Shift + F10

Display the context menu

0
Ctrl + ↑  Shift + F3

Find the previous occurrence of the currently selected text

0
↑  Shift + F12

Displays the list of references for the selected symbol

0
↑  Shift + F11

Step out

0
Ctrl + Alt + H

Display the Threads window

0
Ctrl + 7

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

0
or Ctrl + 7
0
or Ctrl + 8
0
↑  Shift + F9

Display the QuickWatch dialog box

0
Shift + Page Up

Extend selection up one page

0
Ctrl + Insert

Copy to the Clipboard

0
↑  Shift + Insert

Paste from the Clipboard at the insertion point

0
Alt + F5

Start or continue debugging

0
Alt + F6

Move to the next active window in Management Studio

0
Alt + F6

Move to the next tool window

0
↑  Shift +

Reduces the width of the selected control in increments of 8

0
↑  Shift +

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

0
↑  Shift +

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

0
↑  Shift +

Increases the width of the selected control in increments of 8

0
↑  Shift +

Decreases the height of the selected control in increments of 8

0
↑  Shift +

Select text up line by line starting from the cursor

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

1
↑  Shift + Home

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

0
↑  Shift + End

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

0
Ctrl + Space

Complete word

1
Ctrl + Alt + T

Display Template Explorer

0
Ctrl + ↑  Shift + E

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

0
Ctrl + ↑  Shift + W

Open the current file in a browser

0
*

(on the numeric keypad) Expand all tree nodes

‎−1
↑  Shift + Del

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

1
Ctrl + F6

Cycle through the next MDI child windows

0
Ctrl + F9

Enable breakpoint

0
↑  Shift + Alt + T

Moves the line containing the cursor below the next line

0
Ctrl + F10

Implement the Run To Cursor command

0
Alt + F8

Open database in Object Explorer

0
Ctrl + Alt + B

Display the Breakpoints window

0
↑  Shift + Esc

Close the current tool window

0
Ctrl + ↑  Shift + F

Filter the monitor display

0
↑  Shift + F8

Returns the cursor to the last item

0
Ctrl + 6

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

0
Shift + Page Down

Extend selection down one page

0
↑  Shift + F1

Help

0
↑  Shift + F1

Display help for the current editor window

‎−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 + F1

Display SQL Server Books Online

0
F9

Toggle breakpoint

0
F10

Step over

0
Insert

Toggle between insert mode and overtype mode

0
Ctrl + F3

Find the next occurrence of the currently selected text

0
Ctrl + 3

Set next statement

0
Ctrl + 3

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

0
Ctrl + 3

Displays the SQL pane of the Query Designer

0
Ctrl + 4

Displays the results pane of the Query Designer

0
Ctrl + 4

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

1
F8

Display Object Explorer

0
F8

Show all columns

0
Page Up

Move the cursor up one screen

0
Page Down

Move the cursor down one screen

‎−1
Ctrl + 2

Run the sp_lock system stored procedure

0
Ctrl + 2

Displays the criteria pane of the Query Designer

0
Ctrl + 5

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

‎−1
Ctrl + H

Display the Replace dialog box

0
F12

Displays the definition for the selected symbol

0
Ctrl + 1

Run the sp_who system stored procedure

0
Ctrl + 1

Displays the diagram pane of the Query Designer

0
Ctrl + T

Output results in text format

0
Ctrl + T

Swap the characters on either side of the cursor (Does not apply to the SQL Editor)

0
Ctrl + T

Cancels or stops the currently running query

0
Ctrl + N

Open a new query with current connection

0
Ctrl + N

Display the New File dialog box to create a new file

0
Ctrl + N

Display the New File dialog box to create a file

0
F1

Help

0
F7

Display the Summary Window

0
F7

Apply filter

0
F2

Change the name of the selected object

0
Tab

Insert the number of spaces configured for the editor

0
Tab

Increase line indent

0
Tab

then UP arrow or DOWN arrow:  Control the splitter bar that separates the Object Explorer Details list view and Object Explorer Details property pane to adjust the size of the display pane

0
Tab

Moves to the next control on the page


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