SQL Server Management Studio (SSMS) keyboard shortcuts 

SQL Server Management Studio (SSMS)    

Zeynel -
7 years ago
- Shortcuts
0
Ctrl + Home

Move the cursor to the beginning of the document

0
Ctrl + ↑  Shift + I

Reverse incremental search so it starts at the bottom of the file and searches to the top

0
Ctrl + 4

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

0
Ctrl + 4

Displays the results pane of the Query Designer

0
Insert

Toggle between insert mode and overtype mode

0
Ctrl + End

Move the cursor to the end of the document

0
↑  Shift +

Select text up line by line starting from the cursor

0
↑  Shift +

Decreases the height of the selected control in increments of 8

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

Close the current MDI child window

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

Delete the word to the right of the cursor

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

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

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

-1
↑  Shift + Del

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

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 + 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 + ↑  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 + 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 + Alt + C

Display the Call Stack window

0
Ctrl + ↑  Shift +

Extend the selection one word to the left

0
Ctrl + 8

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

1
Ctrl + F6

Cycle through the next MDI child windows

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

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

0
↑  Shift + F6

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

0
Ctrl + F3

Find the next occurrence of the currently selected text

0
Ctrl + Alt + R

Display the Browser Window

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

Copy to the Clipboard

0
Ctrl + F1

Display SQL Server Books Online

0
Ctrl + Alt + L

Display Solution Explorer

0
or Ctrl + Alt + L
0
↑  Shift + F1

Display help for the current editor window

0
↑  Shift + End

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

0
Ctrl + Alt + P

Open SQL Server Profiler

Advertisement

0
↑  Shift + Insert

Paste from the Clipboard at the insertion point

1
↑  Shift + Home

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

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

Returns the cursor to the last item

0
↑  Shift + F9

Display the QuickWatch dialog box

0
↑  Shift + F12

Displays the list of references for the selected symbol

0
Ctrl + Alt + I

Display the Immediate window

0
Shift + Page Up

Extend selection up 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
Shift + Page Down

Extend selection down one page

0
Ctrl + Alt + B

Display the Breakpoints window

0
Ctrl + Alt +

Display a popup listing all open windows

-1
Ctrl + ↑  Shift + Q

Display the Query Designer

0
Ctrl + ↑  Shift + Q

Display the Query Designer dialog from the query editor window

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

Display the Output window

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

Implement the Run To Cursor command

0
↑  Shift + Alt +

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

0
Alt + F8

Open database in Object Explorer

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
Ctrl + Alt + H

Display the Threads window

0
Ctrl + ↑  Shift + ]

Move the cursor to the next brace, extending the selection

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

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

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

Display the Toolbox

0
Ctrl + ↑  Shift + F3

Find the previous occurrence of the currently selected text

0
Alt + F6

Move to the next tool window

0
Alt + F6

Move to the next active window in Management Studio

0
Ctrl + ↑  Shift + F6

Move to the previous document in the editor or designer

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)

-1
Alt + +

Activate the menu for a tool component

0
Alt + +

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

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

Display the estimated execution plan

0
↑  Shift + Alt

Move to the current tool window toolbar

0
Ctrl + ↑  Shift + Alt + M

Include actual execution plan in the query output

1
↑  Shift + Alt + F10

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

0
↑  Shift + Alt + ⤶ Enter

Toggle the full-screen display

0
Ctrl + Alt +   

Scroll up or down Activity Monitor

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

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

0
Ctrl + K then Ctrl + S

Launch Surround With snippet picker

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

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