Wednesday, January 19, 2011

SQL Server Management Studio (SSMS) – Keyboard Shortcut Keys

Here is list of Shortcut keys to work with SSMS handy.

Action

SSMS-Shortcut Key

Move to the SQL Server Management Studio menu bar

ALT

Activate the menu for a tool component

ALT+HYPHEN

Display the context menu

SHIFT+F10

Display the New File dialog box to create a file

CTRL+N

Display the New Project dialog box to create a new project

CTRL+SHIFT+N

Display the Open File dialog box to open an existing file

CTRL+O

Display the Open Project dialog box to open an existing project

CTRL+SHIFT+O

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

CTRL+SHIFT+A

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

ALT+SHIFT+A

Display the Query Designer

CTRL+SHIFT+Q

Close a menu or dialog box, canceling the action

ESC

Clear all bookmarks

CTRL-SHIFT-F2

Insert or remove a bookmark (toggle)

CTRL+F2

Move to next bookmark

F2

Move to previous bookmark

SHIFT+F2

Cancel a query

ALT+BREAK

Connect

CTRL+O

Disconnect

CTRL+F4

Disconnect and close child window

ALT+F4

Database object information

ALT+F1

Clear the active Editor pane

CTRL+SHIFT+DEL

Comment out code

CTRL+SHIFT+C

Copy

CTRL+C or Ctrl+Insert

Cut

CTRL+X or Shift+Del

Decrease indent

SHIFT+TAB

Delete through the end of a line in the Editor pane

CTRL+DEL

Find

CTRL+F

Go to a line number

CTRL+G

Increase indent

TAB

Make selection lowercase

CTRL+SHIFT+L

Make selection uppercase

CTRL+SHIFT+U

Paste

CTRL+V or Shift+Insert

Remove comments

CTRL+SHIFT+R

Repeat last search or find next

F3

Replace

CTRL+H

Select all

CTRL+A

Undo

CTRL+Z

Execute a query

F5 or Ctrl + E

Help for Query Analyzer

F1

Help for the selected Transact-SQL statement

SHIFT+F1

Switch between query and result panes

F6

Switch panes

Shift+F6

Window Selector

CTRL+W

New Query window

CTRL+N

Object Browser (show/hide)

F8

Object Search

F4

Parse the query and check syntax

CTRL+F5

Print

CTRL+P

Display results in grid format

CTRL+D

Display results in text format

CTRL+T

Move the splitter

CTRL+B

Save results to file

CTRL+SHIFT+F

Show Results pane (toggle)

CTRL+R

Save

CTRL+S

Insert a template

CTRL+SHIFT+INSERT

Replace template parameters

CTRL+SHIFT+M

Display estimated execution plan

CTRL+L

Display execution plan (toggle ON/OFF)

CTRL+K

Index Tuning Wizard

CTRL+I

Show client statistics

CTRL+SHIFT+S

Show server trace

CTRL+SHIFT+T

Use database

CTRL+U


 


 

0 comments:

Post a Comment