SQL Server Management Studio (SSMS) keyboard shortcuts

SQL Server Management Studio (SSMS)

defkey.com -
6 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

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!