SQL Server Management Studio (SSMS) keyboard shortcuts

SQL Server Management Studio (SSMS)  

defkey.com -
6 years ago
- Shortcuts
0
Ctrl + F5

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

0
Ctrl + ↑  Shift + Alt + L

Display the estimated execution plan

0
Alt + Break

Cancel the executing query

0
Ctrl + ↑  Shift + Alt + M

Include actual execution plan in the query output

0
Ctrl + ↑  Shift + D

Output results in a grid

0
Ctrl + T

Output results in text format

0
Ctrl + ↑  Shift + T

Output results to a file

0
Ctrl + R

Show or hide the query results pane

0
Ctrl + ↑  Shift + Alt + R

Show the query results pane

0
F6

Toggle between query and results pane

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

Open SQL Server Profiler

0
Ctrl + ↑  Shift + Q

Display the Query Designer dialog from the query editor window

0
Alt + F1

Run the sp_help system stored procedure

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
or Ctrl + 6
0
or Ctrl + 7
0
or Ctrl + 7
0
or Ctrl + 8
0
or Ctrl + 9
0
or Ctrl + 0

Advertisement

0
⤶ Enter

Insert a new line

0
or ↑  Shift + ⤶ Enter
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
Backspace

Delete one character to the left of the cursor

0
or ↑  Shift + Backspace
0
Ctrl + K

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

0
Tab

Insert the number of spaces configured for the editor

0
Ctrl + ⤶ Enter

Insert a blank line above the cursor

1
Ctrl + ↑  Shift + ⤶ Enter

Insert a blank line below the cursor

1
Ctrl + ↑  Shift + L

Change the selected text to lowercase

1
Ctrl + ↑  Shift + U

Change the selected text to uppercase

0
Insert

Toggle between insert mode and overtype mode

0
↑  Shift + Tab

Move selected lines to the left on tab stop

0
Ctrl + Del

Delete the word to the right of the cursor

0
Ctrl + Backspace

Delete the word to the left of the cursor

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 + K then Ctrl + F

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

1
Ctrl + K then Ctrl + H

Set or remove a shortcut in the current line

0
Ctrl + K then Ctrl + U

Remove the comment syntax from the current line

0
Ctrl + R then Ctrl + W

Shows or hides spaces and tabs

0
Alt + F then Ctrl + W

Enables or disables word wrap in an editor

0
Ctrl + M then Ctrl + A

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

0
Ctrl + M then Ctrl + S

Collapses the currently selected outlining region

0
Ctrl + M then Ctrl + X

Expands all outlining regions on the page

0
Ctrl + M then Ctrl + E

Expands the currently selected outlining region

0
Ctrl + M then Ctrl + O

Collapses existing outlining regions

0
Ctrl + M then Ctrl + H

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

0
Ctrl + M then Ctrl + L

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

0
Ctrl + M then Ctrl + M

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

Advertisement

0
Ctrl + M then Ctrl + P

Removes all outlining information in the document

1
Ctrl + M then Ctrl + U

Removes the outlining information for the currently selected region

0
Alt + F5

Start or continue debugging

0
↑  Shift + F5

Stop debugging

0
F11

Step into

0
F10

Step over

0
↑  Shift + F11

Step out

0
↑  Shift + Alt + F11

Step into specific statement

0
Ctrl + 3

Set next statement

0
Alt + Num Lock

Show next statement

0
Ctrl + F10

Implement the Run To Cursor command

0
Ctrl + Alt + Q

Display the QuickWatch dialog box

0
or ↑  Shift + F9
0
F9

Toggle breakpoint

0
Ctrl + F9

Enable breakpoint

0
Alt + F9 then D

D Delete the breakpoint. Only available in the Breakpoints window

1
Alt + F9 then L

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

0
Ctrl + ↑  Shift + F9

Delete all breakpoints

0
Ctrl + Alt + B

Display the Breakpoints window

0
Ctrl + Alt + Break

Break all

0
Ctrl + B

Break at function

0
Ctrl + Alt + W then 1

Display the Watch 1 window

0
Ctrl + Alt + W then 2

Display the Watch 2 window

0
Ctrl + Alt + W then 3

Display the Watch 3 window

0
Ctrl + Alt + W then 4

Display the Watch 4 window

0
Ctrl + Alt + V then A

Display the Autos window

0
Ctrl + Alt + V then L

Display the Locals window

0
Ctrl + Alt + I

Display the Immediate window

0
Ctrl + Alt + C

Display the Call Stack window

0
Ctrl + Alt + H

Display the Threads window

1
Ctrl + ↑  Shift + D then S

Display the Parallel Stacks window

0
Ctrl + ↑  Shift + D then K

Display the Parallel Tasks window

0
Ctrl + J

List members

0
Ctrl + Space

Complete word

0
or Alt +
0
Ctrl + K then Ctrl + I

Display quick information

0
Ctrl + ↑  Shift + Space

Display parameter information

0
Ctrl + ↑  Shift + Alt + C

Copy parameter tip

0
Ctrl + ↑  Shift + Alt + P

Paste parameter tip

0
Ctrl + ]

Jump between syntax pairs

0
Ctrl + K then Ctrl + X

Launch code snippet picker

0
Ctrl + ↑  Shift + R

Refresh local cache

0
Ctrl + K then Ctrl + S

Launch Surround With snippet picker

0
Ctrl + K then Ctrl + B

Display the Code Snippet Manager

0
Alt + +

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

0
Alt + .

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

0
↑  Shift + Alt + ⤶ Enter

Toggle full-screen mode

0
F6

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

0
Ctrl + ↑  Shift + F6

Move to the previous document in the editor or designer

0
or Ctrl + ↑  Shift + Tab
0
↑  Shift + F6

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

0
Alt +

Back, display the previous page in the viewing history

0
Alt +

Forward, display the next page in the viewing history

0
Esc

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

0
Ctrl + Alt + L

Display Solution Explorer

0
Ctrl + N

Display the New File dialog box to create a new file

0
Ctrl + ↑  Shift + N

Display the New Project dialog box to create a new project

0
Ctrl + O

Display the Open File dialog box to open an existing file

0
F2

Change the name of the selected object

0
F1

Help

0
or ↑  Shift + F1
0
Ctrl + F1

Display SQL Server Books Online

0
Ctrl + Alt + F1

Open the Help Library Manager

0
Ctrl + Alt + F2

Display the SQL Server Resource Center Web page

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

0
↑  Shift + F12

Displays the list of references for the selected symbol

-1
Ctrl + H

Display the Replace dialog box

0
Ctrl + I

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

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

Find the previous occurrence of the currently selected text

0
Ctrl + ↑  Shift + H

Display the Replace in Files dialog box

0
Ctrl + ↑  Shift + I

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

0
Alt + F3 then B

Select or clear the Search up option in Find and Replace

0
Alt + F3 then S

Stop the Find in Files search

0
Alt + F3 then W

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

0
Alt + F3 then P

Select or clears the Wildcard option in Find and Replace

0
Ctrl + /

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

0
Ctrl + X

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

-1
or ↑  Shift + Del
0
Ctrl + L

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


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


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.


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