SQL Server Management Studio (SSMS) keyboard shortcuts

SQL Server Management Studio (SSMS)  

defkey.com -
6 years ago
- Shortcuts
2
Alt

Move to the SQL Server Management Studio menu bar

-1
Alt + +

Activate the menu for a tool component

1
↑  Shift + F10

Display the context menu

0
Ctrl + N

Display the New File dialog box to create a file

-1
Ctrl + ↑  Shift + N

Display the New Project dialog box to create a new project

1
Ctrl + O

Display the Open File dialog box to open an existing file

1
Ctrl + ↑  Shift + G

Display the Open File dialog box to open an existing file

0
Ctrl + ↑  Shift + O

Display the Open Project dialog box to open an existing project

0
Ctrl + ↑  Shift + A

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

0
↑  Shift + Alt + A

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

0
Ctrl + ↑  Shift + Q

Display the Query Designer

-1
Esc

Close a menu or dialog box, canceling the action

Advertisement

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

0
Ctrl + P

Print

0
Alt + F4

Exit

0
↑  Shift + Alt + ⤶ Enter

Toggle full screen mode

0
↑  Shift + Esc

Close the current tool window

1
Ctrl + F6

Cycle through the next MDI child windows

0
Ctrl + Tab

Display the IDE navigator with the first document window selected

0
Ctrl + ↑  Shift + Tab

Cycle through the previous MDI child windows

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

Move to the current tool window toolbar

0
Alt + F7

Display the IDE navigator with the first tool window selected

0
Alt + F6

Move to the next tool window

0
F6

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

0
↑  Shift + Alt + F7

Move to the previous tool window

1
F6

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

1
↑  Shift + Alt + F6

Move to the previously selected window

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

Display the dock menu

0
Ctrl + Alt +

Display a popup listing all open windows

1
Ctrl + O

Opens a new query editor window

1
F8

Display Object Explorer

0
Ctrl + Alt + G

Display Registered Servers

1
Ctrl + Alt + T

Display Template Explorer

0
Ctrl + Alt + L

Display Solution Explorer

0
F7

Display the Summary Window

0
F4

Display the Properties Window

0
Ctrl + Alt + O

Display the Output window

0
Ctrl + \

then T: Display the Task List window

1
Ctrl + \

then Ctrl + T: Display the Task List 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
Ctrl + Alt + X

Display the Toolbox

0
Ctrl + K

then Ctrl + W: Display the Bookmarks Window

0
Ctrl + Alt + R

Display the Browser Window

1
↑  Shift + Alt + F10

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

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

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

0
Alt +

Display the previous page in the viewing history. Available only in the Web browser window

0
Alt +

Display the next page in the viewing history. Available only in the Web browser window

0

Move the cursor left

0

Move the cursor right

Advertisement

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

Move the cursor to the beginning of the document

0
Ctrl + End

Move the cursor to the end of the document

0
Page Up

Move the cursor up one screen

0
Page Down

Move the cursor down one screen

0
Ctrl +

Moves the cursor one word to the right

0
Ctrl +

Moves the cursor one word to the left

0
↑  Shift + F8

Returns the cursor to the last item

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

Moves the cursor to the bottom of the document

0
Ctrl + Page Down

Moves to the next tab in the document

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

2
↑  Shift + Home

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

0
↑  Shift + Alt + Home

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

0
↑  Shift + End

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

0
↑  Shift + Alt + End

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

0
↑  Shift +

Select text down line by line starting from the cursor

Note: I'm not sure if below shortcut is correct. It's listed in Microsoft's documents. Please let me know in comments if you know the correct one.
0
↑  Shift + Ctrl + Del

Moves the cursor down one line, extending the column selection

0
↑  Shift +

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

0
↑  Shift + Alt +

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

0
↑  Shift +

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

0
↑  Shift + Alt +

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

0
↑  Shift +

Select text up line by line starting from the cursor

0
↑  Shift + Alt +

Move the cursor up one line, extending the selection

0
Shift + Page Up

Extend selection up one page

0
Shift + Page Down

Extend selection down one page

0
Ctrl + A

Select the entire current document

0
Ctrl + W

Select the word containing the cursor, or the closest word

0
Ctrl + =

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

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 +

Extend the selection one word to the right

0
Ctrl + ↑  Shift +

Extend the selection one word to the left

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

Move the cursor to the next brace, extending the selection

0
Ctrl + =

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

-1
Ctrl + -

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

0
Ctrl + ↑  Shift + -

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

0
Ctrl + K

then Ctrl + A: Swaps the anchor and end points of the current 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 + K

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

0
Ctrl + K

then Ctrl + N  Next bookmark

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

then Ctrl + P:  Previous bookmark

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

then Ctrl + L: Clear bookmarks

0
-

(on the numeric keypad) Collapse tree nodes

0
*

(on the numeric keypad) Expand all tree nodes

0
Ctrl +

Scroll the tree control up in the window

0
Ctrl +

Scroll the tree control down in the window

0
↑  Shift + Alt + ⤶ Enter

Toggle the full-screen display

0
Ctrl +

Scroll text up one line

0
Ctrl +

Scroll text down one line

1
Ctrl + Z

Reverse the last editing action

0
or Alt + Backspace
0
Ctrl + ↑  Shift + Z

Restore the previously undone edit

0
or Ctrl + Y
0
or Alt + ↑  Shift + Backspace
0
Ctrl + S

Save the selected item

0
Ctrl + ↑  Shift + S

Save all

0
Ctrl + F4

Close

0
Ctrl + P

Print

0
Alt + F4

Exit

0
Ctrl + ↑  Shift + W

Open the current file in a browser

0
Ctrl + ↑  Shift + Del

Delete all text in the current file

0
Ctrl + G

Display the Go To Line dialog box

0
Ctrl + +

Display the Navigate To dialog box.

0
Tab

Increase line indent

0
↑  Shift + Tab

Decrease line indent

0
Ctrl + ↑  Shift + U

Make the selected text upper case

0
Ctrl + U

Make the selected text lower case

0
Ctrl + K

then Ctrl + C:  Make the selected text a comment

0
Ctrl + K

then Ctrl + U:  Uncomment the selected text

0
Ctrl + N

Open a new query with current connection

0
Alt + F8

Open database in Object Explorer

0
Ctrl + ↑  Shift + M

Specify values for template parameters

0
F5

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

0
or Ctrl + ↑  Shift + E

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)

SQL Server Management Studio (SMSS) is an integrated environment for managing any SQL infrastructure. It allows you to manage, configure and develop components of SQL Server, Azure SQL Database, and SQL Data Warehouse.

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

Last update: 9/6/2020 12:02 PM UTC

How easy to press shortcuts: 73%

More information >>

Shortcut count: 328

Platform detected: Windows or Linux



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


 
No comments yet. Ask, or type the first one!