SQL Server Management Studio (SSMS) keyboard shortcuts 

SQL Server Management Studio (SSMS)    

Zeynel -
7 years ago
- Shortcuts
0
Ctrl + ↑  Shift + L

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

0
Ctrl + C

Copy to the Clipboard

0
or Ctrl + Insert
0
Ctrl + V

Paste from the Clipboard at the insertion point

0
or ↑  Shift + Insert
0
Ctrl + ↑  Shift + V

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

0
or Ctrl + ↑  Shift + Insert

Advertisement

0
CTRLl + Alt + A

Launches Activity Monitor

0
Ctrl + F4

Closes Activity Monitor

0
F5

Refresh

0
Ctrl + ↑  Shift + F

Filter the monitor display

0
F6

Cycle through panels

0
Ctrl + +

Expand or collapse selected pane

0
or Ctrl + -
0
+

Expand or collapse all panes

0
or -
0
Ctrl + C

Copies entire selected row in grid

0
Ctrl + ↑  Shift + C

Copy cell

0
Alt +

Drop-down for filtering in grid

0
Ctrl + Alt +   

Scroll up or down Activity Monitor

0
F5

Refresh

0
⤶ Enter

Open a detail window from a grid

0
F6

Define filter

0
F7

Apply filter

0
F8

Show all columns

0
Ctrl + T

Cancels or stops the currently running query

0
Ctrl + 1

Displays the diagram pane of the Query Designer

0
Ctrl + 2

Displays the criteria pane of the Query Designer

0
Ctrl + 3

Displays the SQL pane of the Query Designer

0
Ctrl + 4

Displays the results pane of the Query Designer

0
Ctrl + R

Run the query specified in the Query Designer

0
Ctrl + G

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

0
Ctrl + ↑  Shift + J

Enables JOIN mode in the Query Designer

0

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

0

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

0

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

0

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

0
↑  Shift +

Increases the height of the selected control in increments of 8

0
↑  Shift +

Reduces the width of the selected control in increments of 8

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
Tab

Moves to the next control on the page

0
↑  Shift + Tab

Moves to the previous control on the page

0
⤶ Enter

Display the grid on the design surface


Share this page on:
Is this page helpful?
0 0

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