SQL Server Management Studio (SSMS) keyboard shortcuts 

SQL Server Management Studio (SSMS)    

Zeynel -
7 years ago
- Shortcuts
0
Esc

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

-1
Esc

Close a menu or dialog box, canceling the action

1
Esc

Close a menu or dialog box, cancels an operation in progress, or focuses on the current document window

0
End

Move the cursor to the end of the line

-1
Home

Move the cursor to the beginning of the line

0
F6

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

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

0
F6

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

0
F6

Toggle between query and results pane

0
F6

Define filter

0
F6

Cycle through panels

0
F5

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

0
F5

Refresh

0
or F5
0
Ctrl + R

Run the query specified in the Query Designer

0
Ctrl + R

Show or hide the query results pane

0
Ctrl + S

Save the selected item

0
Ctrl + C

Copy to the Clipboard

0
Ctrl + C

Copies entire selected row in grid

0
Ctrl + X

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

0
Del

Delete one character to the right of the cursor

0
Ctrl + V

Paste from the Clipboard at the insertion point

0
Ctrl + Y

Restore the previously undone edit

0
Ctrl + A

Select the entire current document

1
Ctrl + Z

Reverse the last editing action

0
Ctrl + F

Display the Find dialog box

0
F3

Find the next occurrence of the previous search text

0
Ctrl + G

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

0
Ctrl + G

Display the Go To Line dialog box

0
↑  Shift + F3

Find the previous occurrence of the search text

0
F4

Display the Properties Window

0
Ctrl + W

Select the word containing the cursor, or the closest word

0
Ctrl + F4

Close the current MDI child window

0
Ctrl + F4

Close

0
Ctrl + F4

Closes Activity Monitor

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
Ctrl + 1

Run the sp_who system stored procedure

0
Ctrl + 1

Displays the diagram pane of the Query Designer

-1
Ctrl + H

Display the Replace dialog box

0
Ctrl + B

Break at function

0
F12

Displays the definition for the selected symbol

0

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

0

Move the cursor right

0

Move the cursor left

0

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

0
F11

Step into

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

Advertisement

0

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

0

Move the cursor down

0

Move the cursor up

0

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

0
⤶ Enter

Insert a new line

0
⤶ Enter

Display the grid on the design surface

0
⤶ Enter

Open a detail window from a grid

0
F1

Help

0
F10

Step over

0
F9

Toggle breakpoint

0
Insert

Toggle between insert mode and overtype mode

1
F8

Display Object Explorer

0
F8

Show all columns

0
Ctrl + F3

Find the next occurrence of the currently selected text

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

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
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
↑  Shift + F1

Help

0
↑  Shift + F1

Display help for the current editor window

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
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
↑  Shift + Esc

Close the current tool window

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

Returns the cursor to the last item

0
Ctrl + Alt + B

Display the Breakpoints window

0
*

(on the numeric keypad) Expand all tree nodes

0
Alt + F8

Open database in Object Explorer

0
Ctrl + ↑  Shift + F

Filter the monitor display

0
Ctrl + ↑  Shift + Z

Restore the previously undone edit

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
Alt + F7

Display the IDE navigator with the first tool window selected

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 + 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
↑  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 + 0

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

-1
↑  Shift + Del

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

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

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
Ctrl + ↑  Shift + W

Open the current file in a browser

0
+

Expand or collapse all panes

0
or -
0
-

(on the numeric keypad) Collapse tree nodes

0
Ctrl +

Moves the cursor one word to the left

0
Ctrl +

Moves the cursor one word to the right

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


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: 6/9/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