SQL Server Management Studio (SSMS) keyboard shortcuts 

SQL Server Management Studio (SSMS)    

Zeynel -
7 years ago
- Shortcuts
0
Ctrl + N

Display the New File dialog box to create a file

-1
Esc

Close a menu or dialog box, canceling the action

0
Ctrl + F4

Close the current MDI child window

1
Esc

Close a menu or dialog box, cancels an operation in progress, or focuses on the current document 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
F6

(in the Database Engine Query Editor)  Move to the next tool window

1
F6

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

1
F8

Display Object Explorer

0
F7

Display the Summary Window

0
F4

Display the Properties Window

0
F6

Toggle between Object Explorer Details list view and Object Explorer Details property pane

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

Move the cursor left

0

Move the cursor right

0

Move the cursor up

0

Move the cursor down

-1
Home

Move the cursor to the beginning of the line

0
End

Move the cursor to the end of the line

0
Page Up

Move the cursor up one screen

0
Page Down

Move the cursor down one screen

0
Ctrl + A

Select the entire current document

0
Ctrl + W

Select the word containing the cursor, or the closest word

1
Ctrl + Z

Reverse the last editing action

0
Ctrl + Y

Restore the previously undone edit

0
Ctrl + S

Save the selected item

0
Ctrl + F4

Close

0
Ctrl + G

Display the Go To Line dialog box

0
Tab

Increase line indent

0
Ctrl + N

Open a new query with current connection

0
F5

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

0
Ctrl + T

Output results in text format

0
F6

Toggle between query and results pane

0
Ctrl + R

Show or hide the query results pane

0
Ctrl + 1

Run the sp_who system stored procedure

-1
Ctrl + 2

Run the sp_lock system stored procedure

0
Ctrl + 3

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

0
or Ctrl + 4
0
or Ctrl + 5
0
Ctrl + T

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

0
Del

Delete one character to the right of the cursor

0
⤶ Enter

Insert a new line

0
Tab

Insert the number of spaces configured for the editor

0
Insert

Toggle between insert mode and overtype mode

0
F11

Step into

0
F10

Step over

0
Ctrl + 3

Set next statement

0
F9

Toggle breakpoint

0
Ctrl + B

Break at function

0
F6

Move to the next pane of a split pane view of a document

0
Esc

Closes a menu or dialog box, cancels an operation in progress, or places focus in the current window

0
Ctrl + N

Display the New File dialog box to create a new file

0
F1

Help

0
or ↑  Shift + F1
0
Ctrl + F1

Display SQL Server Books Online

0
F2

Change the name of the selected object

0
↑  Shift + F1

Display help for the current editor window

0
Ctrl + F

Display the Find dialog box

0
F12

Displays the definition for the selected symbol

-1
Ctrl + H

Display the Replace dialog box

Advertisement

0
F3

Find the next occurrence of the previous search text

0
↑  Shift + F3

Find the previous occurrence of the search text

0
Ctrl + F3

Find the next occurrence of the currently selected text

0
Ctrl + X

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

0
Ctrl + V

Paste from the Clipboard at the insertion point

0
Ctrl + C

Copy to the Clipboard

0
Ctrl + F4

Closes Activity Monitor

0
F5

Refresh

0
F6

Cycle through panels

0
Ctrl + C

Copies entire selected row in grid

0
F5

Refresh

0
⤶ Enter

Open a detail window from a grid

0
Ctrl + T

Cancels or stops the currently running query

0
Ctrl + 1

Displays the diagram pane of the Query Designer

0
Ctrl + 2

Displays the criteria pane of the Query Designer

0
Ctrl + 3

Displays the SQL pane of the Query Designer

0
Ctrl + 4

Displays the results pane of the Query Designer

0
Ctrl + R

Run the query specified in the Query Designer

0
Ctrl + G

When in the results pane, moves focus to the tool strip docked at the bottom of the designer

0

Move the selected control down in increments of 8 on the design surface

0

Move the selected control left in increments of 8 on the design surface

0

Move the selected control right in increments of 8 on the design surface

0

Move the selected control up in increments of 8 on the design surface

0
F6

Define filter

0
F7

Apply filter

0
F8

Show all columns

0
Tab

Moves to the next control on the page

0
⤶ Enter

Display the grid on the design surface

0
↑  Shift +

Increases the height of the selected control in increments of 8

0
↑  Shift +

Reduces the width of the selected control in increments of 8

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
+

Expand or collapse all panes

0
or -
0
Ctrl + ↑  Shift + C

Copy cell

0
Ctrl + ↑  Shift + F

Filter the monitor display

0
Ctrl + Insert

Copy to the Clipboard

0
↑  Shift + Insert

Paste from the Clipboard at the insertion point

0
Ctrl + ↑  Shift + V

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

-1
↑  Shift + Del

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

0
Ctrl + ↑  Shift + F3

Find the previous occurrence of the currently selected text

0
Ctrl + ↑  Shift + H

Display the Replace in Files dialog box

0
↑  Shift + F12

Displays the list of references for the selected symbol

0
Ctrl + ↑  Shift + N

Display the New Project dialog box to create a new project

0
↑  Shift + F6

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

0
Ctrl + ↑  Shift + R

Refresh local cache

0
Ctrl + Alt + B

Display the Breakpoints window

0
Ctrl + Alt + H

Display the Threads window

0
Ctrl + J

List members

0
Ctrl + Space

Complete word

0
Ctrl + F9

Enable breakpoint

0
Ctrl + F10

Implement the Run To Cursor command

0
↑  Shift + F9

Display the QuickWatch dialog box

0
Alt + F5

Start or continue debugging

0
↑  Shift + F5

Stop debugging

0
↑  Shift + F11

Step out

0
Ctrl + Del

Delete the word to the right of the cursor

0
Ctrl + ⤶ Enter

Insert a blank line above the cursor

0
↑  Shift + ⤶ Enter

Insert a new line

0
Ctrl + ↑  Shift + D

Output results in a grid

0
Ctrl + K

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

0
Ctrl + ↑  Shift + T

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

0
↑  Shift + Alt + T

Moves the line containing the cursor below the next line

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

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

0
or Ctrl + 7
0
or Ctrl + 7
0
or Ctrl + 8
0
or Ctrl + 9
0
or Ctrl + 0
0
Ctrl + ↑  Shift + Q

Display the Query Designer dialog from the query editor window

0
Ctrl + ↑  Shift + C

Copy the result grid and headers to the clipboard

0
Alt + F6

Move to the next active window in Management Studio

0
Ctrl + ↑  Shift + T

Output results to a file

0
Ctrl + ↑  Shift + E

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

0
Ctrl + F5

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

0
Alt + F8

Open database in Object Explorer

0
Ctrl + ↑  Shift + M

Specify values for template parameters

0
Ctrl + U

Make the selected text lower case

0
Ctrl + K

then Ctrl + C:  Make the selected text a comment

-1
Ctrl + K

then Ctrl + U:  Uncomment the selected text

0
Ctrl + ↑  Shift + W

Open the current file in a browser

0
Ctrl + ↑  Shift + S

Save all

0
Ctrl + ↑  Shift + Z

Restore the previously undone edit

0
Ctrl +

Scroll text up one line

0
Ctrl +

Scroll text down one line

0
Ctrl + K

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

0
Ctrl + =

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

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 + P:  Previous bookmark


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

Program information

Program name: SQL Server Management Studio (SSMS) SQL Server Management Studio (SSMS) (Developer tools)

Web page: microsoft.com/en-us/sql-server...

Last update: 06.09.2020 12:02 UTC

How easy to press shortcuts: 73%

More information >>

Shortcut count: 328

Platform detected: Windows or Linux

Similar programs



User operations

Add SQL Server Management Studio (SSMS) to your list of favorites

Advertisement


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