SQL Server Management Studio (SSMS) keyboard shortcuts

SQL Server Management Studio (SSMS)

defkey.com -
22 months ago
- Shortcuts
Alt

Move to the SQL Server Management Studio menu bar

Alt + +

Activate the menu for a tool component

↑   Shift + F10

Display the context menu

Ctrl + N

Display the New File dialog box to create a file

Ctrl + ↑   Shift + N

Display the New Project dialog box to create a new project

Ctrl + O

Display the Open File dialog box to open an existing file

Ctrl + ↑   Shift + G

Display the Open File dialog box to open an existing file

Ctrl + ↑   Shift + O

Display the Open Project dialog box to open an existing project

Ctrl + ↑   Shift + A

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

Alt + ↑   Shift + A

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

Ctrl + ↑   Shift + Q

Display the Query Designer

Esc

Close a menu or dialog box, canceling the action

Ctrl + F4

Close the current MDI child window

Esc

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

Ctrl + P

Print

Alt + F4

Exit

↑   Shift + Alt + ⤶ Enter

Toggle full screen mode

↑   Shift + Esc

Close the current tool window

Ctrl + F6

Cycle through the next MDI child windows

Ctrl + ⭾ Tab

Display the IDE navigator with the first document window selected

Ctrl + ↑   Shift + ⭾ Tab

Cycle through the previous MDI child windows

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

↑   Shift + Alt

Move to the current tool window toolbar

Alt + F7

Display the IDE navigator with the first tool window selected

Alt + F6

Move to the next tool window

F6

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

↑   Shift + Alt + F7

Move to the previous tool window

F6

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

Alt + ↑   Shift + F6

Move to the previously selected window

↑   Shift + F6

(in the Database Engine Query Editor) Move to the next pane of a split pane view of a single document

↑   Shift + F6

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

Alt + -

Display the dock menu

Ctrl + Alt +

Display a popup listing all open windows

Ctrl + O

Opens a new query editor window

F8

Display Object Explorer

Ctrl + Alt + G

Display Registered Servers

Ctrl + Alt + T

Display Template Explorer

Ctrl + Alt + L

Display Solution Explorer

F7

Display the Summary Window

F4

Display the Properties Window

Ctrl + Alt + O

Display the Output window

Ctrl + \

then T: Display the Task List window

Ctrl + \

then Ctrl + T: Display the Task List window

F6

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

⭾ 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

Ctrl + Alt + X

Display the Toolbox

Ctrl + K

then Ctrl + W: Display the Bookmarks Window

Ctrl + Alt + R

Display the Browser Window

↑   Shift + Alt + F10

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

Ctrl + \

then Ctrl + E  Display the Error List Window (Transact-SQL Editor only)

Ctrl + \

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

Ctrl + \

then E   Display the Error List Window (Transact-SQL Editor only)

Ctrl + ↑   Shift + F12

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

Alt +

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

Alt +

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

Move the cursor left

Move the cursor right

Move the cursor up

Move the cursor down

Home

Move the cursor to the beginning of the line

End

Move the cursor to the end of the line

Ctrl + Home

Move the cursor to the beginning of the document

Ctrl + End

Move the cursor to the end of the document

Page Up

Move the cursor up one screen

Page Down

Move the cursor down one screen

Ctrl +

Moves the cursor one word to the right

Ctrl +

Moves the cursor one word to the left

↑   Shift + F8

Returns the cursor to the last item

Ctrl + Page Up

Moves the cursor to the top of the document

Ctrl + Page Up

Moves to the previous tab in the document

Ctrl + Page Down

Moves the cursor to the bottom of the document

Ctrl + Page Down

Moves to the next tab in the document

Ctrl + ↑   Shift + Home

Select text from the cursor to the beginning of the document

Ctrl + ↑   Shift + End

Select text from the cursor to the end of the document

↑   Shift + Home

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

↑   Shift + Alt + Home

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

↑   Shift + End

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

↑   Shift + Alt + End

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

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

Moves the cursor down one line, extending the column selection

↑   Shift +

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

Alt + ↑   Shift +

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

↑   Shift +

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

Alt + ↑   Shift +

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

↑   Shift +

ARROW  Select text up line by line starting from the cursor

Alt + ↑   Shift +

Move the cursor up one line, extending the selection

Shift + Page Up

Extend selection up one page

Shift + Page Down

Extend selection down one page

Ctrl + A

Select the entire current document

Ctrl + W

Select the word containing the cursor, or the closest word

Ctrl + =

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

Ctrl + Shift + Page Up

Extend the selection to the top of the current window

Ctrl + Shift + Page Down

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

↑   Shift + Ctrl +

Extend the selection one word to the right

↑   Shift + Ctrl +

Extend the selection one word to the left

Ctrl + ↑   Shift + Alt +

Move the cursor to the right one word, extending the selection

Ctrl + ↑   Shift + Alt +

Move the cursor to the left one word, extending the selection

Ctrl + ↑   Shift + ]

Move the cursor to the next brace, extending the selection

Ctrl + =

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

Ctrl + -

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

Ctrl + ↑   Shift + -

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

Ctrl + K

then CtrlA: Swaps the anchor and end points of the current selection

Ctrl + Shift + Page Up

Moves the cursor to the first line in view, extending the selection

Ctrl + Shift + Page Down

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

Ctrl + K

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

Ctrl + K

then Ctrl + N  Next bookmark

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

Ctrl + K

then Ctrl + P:  Previous bookmark

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.

Ctrl + K

then Ctrl + L: Clear bookmarks

-

(on the numeric keypad) Collapse tree nodes

*

(on the numeric keypad) Expand all tree nodes

Ctrl +

Scroll the tree control up in the window

Ctrl +

Scroll the tree control down in the window

↑   Shift + Alt + ⤶ Enter

Toggle the full-screen display

Ctrl +

Scroll text up one line

Ctrl +

Scroll text down one line

Ctrl + Z

Reverse the last editing action

or Alt + ⬅ Backspace
Ctrl + ↑   Shift + Z

Restore the previously undone edit

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

Save the selected item

Ctrl + ↑   Shift + S

Save all

Ctrl + F4

Close

Ctrl + P

Print

Alt + F4

Exit

Ctrl + ↑   Shift + W

Open the current file in a browser

Ctrl + ↑   Shift + Del

Delete all text in the current file

Ctrl + G

Display the Go To Line dialog box

Ctrl + +

Display the Navigate To dialog box.

⭾ Tab

Increase line indent

↑   Shift + ⭾ Tab

Decrease line indent

Ctrl + ↑   Shift + U

Make the selected text upper case

Ctrl + U

Make the selected text lower case

Ctrl + K

then Ctrl + C:  Make the selected text a comment

Ctrl + K

then Ctrl + U:  Uncomment the selected text

Ctrl + N

Open a new query with current connection

Alt + F8

Open database in Object Explorer

Ctrl + ↑   Shift + M

Specify values for template parameters

F5

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

or Ctrl + ↑   Shift + E
Ctrl + F5

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

Ctrl + ↑   Shift + Alt + L

Display the estimated execution plan

Alt + Break

Cancel the executing query

Ctrl + ↑   Shift + Alt + M

Include actual execution plan in the query output

Ctrl + ↑   Shift + D

Output results in a grid

Ctrl + T

Output results in text format

Ctrl + ↑   Shift + T

Output results to a file

Ctrl + R

Show or hide the query results pane

Ctrl + Alt + ↑   Shift + R

Show the query results pane

F6

Toggle between query and results pane

Ctrl + ↑   Shift + C

Copy the result grid and headers to the clipboard

Alt + F6

Move to the next active window in Management Studio

Ctrl + Alt + P

Open SQL Server Profiler

Ctrl + ↑   Shift + Q

Display the Query Designer dialog from the query editor window

Alt + F1

Run the sp_help system stored procedure

Ctrl + 1

Run the sp_who system stored procedure

Ctrl + 2

Run the sp_lock system stored procedure

Ctrl + 3

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

or Ctrl + 4
or Ctrl + 5
or Ctrl + 6
or Ctrl + 7
or Ctrl + 7
or Ctrl + 8
or Ctrl + 9
or Ctrl + 0
⤶ Enter

Insert a new line

or ↑   Shift + ⤶ Enter
Ctrl + T

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

Del

Delete one character to the right of the cursor

⬅ Backspace

Delete one character to the left of the cursor

or ↑   Shift + ⬅ Backspace
Ctrl + K

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

⭾ Tab

Insert the number of spaces configured for the editor

Ctrl + ⤶ Enter

Insert a blank line above the cursor

Ctrl + ↑   Shift + ⤶ Enter

Insert a blank line below the cursor

Ctrl + ↑   Shift + L

Change the selected text to lowercase

Ctrl + ↑   Shift + U

Change the selected text to uppercase

Insert

Toggle between insert mode and overtype mode

↑   Shift + ⭾ Tab

Move selected lines to the left on tab stop

Ctrl + Del

Delete the word to the right of the cursor

Ctrl + ⬅ Backspace

Delete the word to the left of the cursor

Ctrl + ↑   Shift + T

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

↑   Shift + Alt + T

Moves the line containing the cursor below the next line

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

Ctrl + K then Ctrl + F

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

Ctrl + K then Ctrl + H

Set or remove a shortcut in the current line

Ctrl + K then Ctrl + U

Remove the comment syntax from the current line

Ctrl + R then Ctrl + W

Shows or hides spaces and tabs

Alt + F then Ctrl + W

Enables or disables word wrap in an editor

Ctrl + M then Ctrl + A

Collapses all outlining regions to show just the outermost groups in the hierarchy

Ctrl + M then Ctrl + S

Collapses the currently selected outlining region

Ctrl + M then Ctrl + X

Expands all outlining regions on the page

Ctrl + M then Ctrl + E

Expands the currently selected outlining region

Ctrl + M then Ctrl + O

Collapses existing outlining regions

Ctrl + M then Ctrl + H

Hides the selected text. A signal icon marks the location of the hidden text

Ctrl + M then Ctrl + L

Toggles all text sections previously marked as hidden between the hidden and display states

Ctrl + M then Ctrl + M

Toggles the currently selected hidden text section between the hidden and display states

Ctrl + M then Ctrl + P

Removes all outlining information in the document

Ctrl + M then Ctrl + U

Removes the outlining information for the currently selected region

Alt + F5

Start or continue debugging

↑   Shift + F5

Stop debugging

F11

Step into

F10

Step over

↑   Shift + F11

Step out

↑   Shift + Alt + F11

Step into specific statement

Ctrl + 3

Set next statement

Alt + Num Lock

Show next statement

Ctrl + F10

Implement the Run To Cursor command

Ctrl + Alt + Q

Display the QuickWatch dialog box

or ↑   Shift + F9
F9

Toggle breakpoint

Ctrl + F9

Enable breakpoint

Alt + F9 then D

D Delete the breakpoint. Only available in the Breakpoints window

Alt + F9 then L

L Open the Edit breakpoint labels dialog. Only available in the Breakpoints window

Ctrl + ↑   Shift + F9

Delete all breakpoints

Ctrl + Alt + B

Display the Breakpoints window

Ctrl + Alt + Break

Break all

Ctrl + B

Break at function

Ctrl + Alt + W then 1

1 Display the Watch 1 window

Ctrl + Alt + W then 2

2 Display the Watch 2 window

Ctrl + Alt + W then 3

3 Display the Watch 3 window

Ctrl + Alt + W then 4

4 Display the Watch 4 window

Ctrl + Alt + V then A

A Display the Autos window

Ctrl + Alt + V then L

L Display the Locals window

Ctrl + Alt + I

Display the Immediate window

Ctrl + Alt + C

Display the Call Stack window

Ctrl + Alt + H

Display the Threads window

Ctrl + ↑   Shift + D then S

S Display the Parallel Stacks window

Ctrl + ↑   Shift + D then K

K Display the Parallel Tasks window

Ctrl + J

List members

Ctrl + Space

Complete word

or Alt +
Ctrl + K then Ctrl + I

Display quick information

Ctrl + ↑   Shift + Space

Display parameter information

Ctrl + ↑   Shift + Alt + C

Copy parameter tip

Ctrl + Alt + ↑   Shift + P

Paste parameter tip

Ctrl + ]

Jump between syntax pairs

Ctrl + K then Ctrl + X

Launch code snippet picker

Ctrl + ↑   Shift + R

Refresh local cache

Ctrl + K then Ctrl + S

Launch Surround With snippet picker

Ctrl + K then Ctrl + B

Display the Code Snippet Manager

Alt + +

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

Alt + .

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

↑   Shift + Alt + ⤶ Enter

Toggle full-screen mode

F6

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

↑   Shift + Ctrl + F6

Move to the previous document in the editor or designer

or Ctrl + ↑   Shift + ⭾ Tab
↑   Shift + F6

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

Alt +

Back, display the previous page in the viewing history

Alt +

Forward, display the next page in the viewing history

Esc

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

Ctrl + Alt + L

Display Solution Explorer

Ctrl + N

Display the New File dialog box to create a new file

Ctrl + ↑   Shift + N

Display the New Project dialog box to create a new project

Ctrl + O

Display the Open File dialog box to open an existing file

F2

Change the name of the selected object

F1

Help

or ↑   Shift + F1
Ctrl + F1

Display SQL Server Books Online

Ctrl + Alt + F1

Open the Help Library Manager

Ctrl + Alt + F2

Display the SQL Server Resource Center Web page

↑   Shift + F1

Display help for the current editor window

Ctrl + F

Display the Find dialog box

F12

Displays the definition for the selected symbol

↑   Shift + F12

Displays the list of references for the selected symbol

Ctrl + H

Display the Replace dialog box

Ctrl + I

Start incremental search. Type the characters to search for or press Ctrl + I to search for characters from the previous search

F3

Find the next occurrence of the previous search text

↑   Shift + F3

Find the previous occurrence of the search text

Ctrl + F3

Find the next occurrence of the currently selected text

Ctrl + ↑   Shift + F3

Find the previous occurrence of the currently selected text

Ctrl + ↑   Shift + H

Display the Replace in Files dialog box

Ctrl + ↑   Shift + I

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

Alt + F3 then B

B Select or clear the Search up option in Find and Replace

Alt + F3 then S

S Stop the Find in Files search

Alt + F3 then W

W Select or clear the Find whole word option in Find and Replace

Alt + F3 then P

Select or clears the Wildcard option in Find and Replace

Ctrl + /

Place the caret in the Find/Command box of the Standard toolbar

Ctrl + X

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

or ↑   Shift + Del
Ctrl + L

Cuts all of the selected lines, or the current line if nothing is selected

or Ctrl + ↑   Shift + L
Ctrl + C

Copy to the Clipboard

or Ctrl + Insert
Ctrl + V

Paste from the Clipboard at the insertion point

or ↑   Shift + Insert
Ctrl + ↑   Shift + V

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

or Ctrl + ↑   Shift + Insert
CTRLl + Alt + A

Launches Activity Monitor

Ctrl + F4

Closes Activity Monitor

F5

Refresh

Ctrl + ↑   Shift + F

Filter the monitor display

F6

Cycle through panels

Ctrl + +

Expand or collapse selected pane

or Ctrl + -
+

Expand or collapse all panes

or -
Ctrl + C

Copies entire selected row in grid

Ctrl + ↑   Shift + C

Copy cell

Alt +

Drop-down for filtering in grid

Ctrl + Alt + ↑  ↓

Scroll up or down Activity Monitor

F5

Refresh

⤶ Enter

Open a detail window from a grid

F6

Define filter

F7

Apply filter

F8

Show all columns

Ctrl + T

Cancels or stops the currently running query

Ctrl + 1

Displays the diagram pane of the Query Designer

Ctrl + 2

Displays the criteria pane of the Query Designer

Ctrl + 3

Displays the SQL pane of the Query Designer

Ctrl + 4

Displays the results pane of the Query Designer

Ctrl + R

Run the query specified in the Query Designer

Ctrl + G

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

Ctrl + ↑   Shift + J

Enables JOIN mode in the Query Designer

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

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

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

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

↑   Shift +

Increases the height of the selected control in increments of 8

↑   Shift +

Reduces the width of the selected control in increments of 8

↑   Shift +

Increases the width of the selected control in increments of 8

↑   Shift +

Decreases the height of the selected control in increments of 8

⭾ Tab

Moves to the next control on the page

↑   Shift + ⭾ Tab

Moves to the previous control on the page

⤶ Enter

Display the grid on the design surface


Share this page on:

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: https://www.microsoft.com/en-u...

Shortcut count: 328

How easy to press shortcuts: 73%

Similar programs


  1. Grand Theft Auto VGrand Theft Auto V
    65883   
  2. Keyboard symbolsKeyboard symbols
    51666    1
  3. Apex Legends (PC)Apex Legends (PC)
    39632   
  4. The Sims 4The Sims 4
    38624    3
  5. PlayerUnknown's BattlegroundsPlayerUnknown's Battleg
    35327    2
  6. DiscordDiscord
    34322   
More keyboard shortcuts...

Advertisement

Join our mailing list!

Your email is kept private and we don't spam.