Categories
General

Short Cut Keys

I have always googled out for finding any shortcut key to be used in SQL Server that gave me an idea to post this. I have gathered all the SQL Server 2000 and 2005 shortcuts with the help of books online and internet here. Hope this helps you.

SQL Server 2000 Query Analyzer Keys:

Shortcut key
Description
CTRL-SHIFT-F2
Clear all bookmarks
CTRL+F2
Insert or remove a bookmark (toggle)
F2
Move to next bookmark
SHIFT+F2
Move to previous bookmark
ALT+BREAK
Cancel a query
CTRL+O
Connect
CTRL+F4
Disconnect
ALT+F4
Disconnect and close child window
ALT+F1
Database object information
CTRL+SHIFT+DEL
Clear the active Editor pane
CTRL+SHIFT+C
Comment out code
CTRL+C or Ctrl+Insert
Copy
CTRL+X or Shift+Del
Cut
SHIFT+TAB
Decrease indent
CTRL+DEL
Delete through the end of a line in the Editor pane
CTRL+F
Find
CTRL+G
Go to a line number
TAB
Increase indent
CTRL+SHIFT+L
Make selection lowercase
CTRL+SHIFT+U
Make selection uppercase
CTRL+V or Shift+Insert
Paste
CTRL+SHIFT+R
Remove comments
F3
Repeat last search or find next
CTRL+H
Replace
CTRL+A
Select all
CTRL+Z
Undo
F5 or Ctrl + E
Execute a query
F1
Help for Query Analyzer
SHIFT+F1
Help for the selected Transact-SQL statement
F6
Switch between query and result panes
Shift+F6
Switch panes
CTRL+W
Window Selector
CTRL+N
New Query window
F8
Object Browser (show/hide)
F4
Object Search
CTRL+F5
Parse the query and check syntax
CTRL+P
Print
CTRL+D
Display results in grid format
CTRL+T
Display results in text format
CTRL+B
Move the splitter
CTRL+SHIFT+F
Save results to file
CTRL+R
Show Results pane (toggle)
CTRL+S
Save
CTRL+SHIFT+INSERT
Insert a template
CTRL+SHIFT+M
Replace template parameters
CTRL+L
Display estimated execution plan
CTRL+K
Display execution plan (toggle ON/OFF)
CTRL+I
Index Tuning Wizard
CTRL+SHIFT+S
Show client statistics
CTRL+SHIFT+T
Show server trace
CTRL+U
Use database

SQL Server 2005 Management studio offer two types of key board schema. They are is the Standard Schema and SQL server 2000 schema. You can opt for the keyboard schema by choosing the option that you want in the options menu.

Action
Standard
SQL Server 2000
Move to the SQL Server Management Studio menu bar
ALT
ALT
Activate the menu for a tool component
ALT+HYPHEN
ALT+HYPHEN
Display the context menu
SHIFT+F10
SHIFT+F10
Display the New File dialog box to create a file
CTRL+N
No equivalent
Display the New Project dialog box to create a new project
CTRL+SHIFT+N
CTRL+SHIFT+N
Display the Open File dialog box to open an existing file
CTRL+O
CTRL+SHIFT+INS
Display the Open Project dialog box to open an existing project
CTRL+SHIFT+O
No equivalent
Display the Add New Item dialog box to add a new file to the current project
CTRL+SHIFT+A
No equivalent
Display the Add Existing Item dialog box to add an existing file to the current project
ALT+SHIFT+A
No equivalent
Display the Query Designer
CTRL+SHIFT+Q
CTRL+SHIFT+Q
Close a menu or dialog box, canceling the action
ESC
ESC
Action Standard SQL Server 2000
Close the current MDI child window CTRL+F4 CTRL+F4
Print CTRL+P CTRL+P
Exit ALT+F4 ALT+F4
Toggle full screen mode SHIFT+ALT+ENTER SHIFT+ALT+ENTER
Close the current tool window SHIFT+ESC SHIFT+ESC
Cycle through the next MDI child windows CTRL+TAB CTRL+TAB
Cycle through the previous MDI child windows CTRL+SHIFT+TAB CTRL+SHIFT+TAB
Move to the current tool window toolbar SHIFT+ALT No equivalent
Move to the next tool window ALT+F6 ALT+F6
Move to the previously selected window SHIFT+ALT+F6 SHIFT+ALT+F6
Opens a new query editor window No equivalent CTRL+O
Display Object Explorer F8 F8
Display Registered Servers CTRL+ALT+R No equivalent
Display Template Explorer CTRL+ALT+T CTRL+ALT+T
Display Solution Explorer CTRL+ALT+L CTRL+ALT+L
Display the Summary Window F7 F7
Display the Properties Window F4 F4
Display the Toolbox CTRL+ALT+X CTRL+ALT+X
Display the Bookmarks Window CTRL+K, CTRL+W No equivalent
Display the Browser Window CTRL_ALT+R CTRL_ALT+R

 

 

 

 

 

 

Action Standard SQL Server 2000
Move the cursor left LEFT ARROW LEFT ARROW
Move the cursor right RIGHT ARROW RIGHT ARROW
Move the cursor up UP ARROW UP ARROW
Move the cursor down DOWN ARROW DOWN ARROW
Move the cursor to the beginning of the line HOME HOME
Move the cursor to the end of the line END END
Move the cursor to the beginning of the document CTRL+HOME CTRL+HOME
Move the cursor to the end of the document CTRL+END CTRL+END
Move the cursor up one screen PAGE UP PAGE UP
Move the cursor down one screen PAGE DOWN PAGE DOWN
Moves the cursor one word to the right CTRL+ RIGHT ARROW CTRL+RIGHT ARROW
Moves the cursor one word to the left CTRL+LEFT ARROW CTRL+LEFT ARROW

 

 

 

 

Action Standard SQL Server 2000
Select text from the cursor to the beginning of the document CTRL+SHIFT+HOME CTRL+SHIFT+HOME
Select text from the cursor to the end of the document CTRL+SHIFT+END CTRL+SHIFT+END
Select text from the cursor to the start of the current line SHIFT+HOME SHIFT+HOME
Select text from the cursor to the end of the current line SHIFT+END SHIFT+END
Select text down line by line starting from the cursor SHIFT+DOWN ARROW SHIFT+DOWN ARROW
Select text up line by line starting from the cursor SHIFT+UP ARROW SHIFT+UP ARROW
Move the cursor up one line, extending the selection SHIFT+ALT+UP ARROW SHIFT+ALT+UP ARROW
Extend selection up one page SHIFT+PAGE UP SHIFT+PAGE UP
Extend selection down one page SHIFT+PAGE DOWN SHIFT+PAGE DOWN
Select the entire current document CTRL+A CTRL+A
Select the word containing the cursor, or the closest word CTRL+W CTRL+W
Select the current location in the editor, back to the previous location in the editor CTRL+= CTRL+=
Extend the selection to the top of the current window CTRL+SHIFT+PAGE UP CTRL+SHIFT+PAGE UP
Move the cursor to the last line in view, extending the selection CTRL+SHIFT+PAGE DOWN CTRL+SHIFT+PAGE DOWN
Extend the selection one word to the right CTRL+SHIFT+

RIGHT ARROW

CTRL+SHIFT+

RIGHT ARROW

Extend the selection one word to the left CTRL+SHIFT+LEFT ARROW CTRL+SHIFT+

LEFT ARROW

Move the cursor to the right one word, extending the selection CTRL+SHIFT+ALT+RIGHT ARROW CTRL+SHIFT+ALT+RIGHT ARROW
Move the cursor to the left one word, extending the selection CTRL+SHIFT+ALT+LEFT ARROW CTRL+SHIFT+ALT+LEFT ARROW

 

 

 

 

 

 

 

 

 

Action Standard SQL Server 2000
Set or remove a bookmark at the current line CTRL+K, CTRL+K CTRL+F2
Next bookmark CTRL+K, CTRL+N F2
Previous bookmark CTRL+K, CTRL+P SHIFT+F2
Clear bookmarks CTRL+K, CTRL+L CTRL+SHIFT+F2

 

 

Action Standard SQL Server 2000
Collapse tree nodes – (on the numeric keypad) – (on the numeric keypad)
Expand all tree nodes * (on the numeric keypad) * (on the numeric keypad)
Scroll the tree control up in the window CTRL+UP ARROW CTRL+UP ARROW
Scroll the tree control down in the window CTRL+ DOWN ARROW CTRL+ DOWN ARROW

 

 

Note: All shortcuts are not implemented in all types of code editors.

Action Standard SQL Server 2000
Toggle the full-screen display SHIFT+ALT+ENTER SHIFT+ALT+ENTER
Scroll text up one line CTRL+UP ARROW CTRL+UP ARROW
Scroll text down one line CTRL+

DOWN ARROW

CTRL+

DOWN ARROW

Reverse the last editing action CTRL+Z CTRL+Z
Restore the previously undone edit CTRL+SHIFT+Z

or

CTRL+Y

or

ALT+SHIFT+BACKSPACE

CTRL+SHIFT+Z

or

CTRL+Y

or

ALT+SHIFT+BACK SPACE

Insert the body of the specified file into the current window. No equivalent CTRL+SHIFT+P
Save the selected item CTRL+S CTRL+S
Save all CTRL+SHIFT+S CTRL+SHIFT+S
Close CTRL+F4 CTRL+F4
Print CTRL+P CTRL+P
Exit ALT+F4 ALT+F4
Delete all text in the current file CTRL+SHIFT+DEL CTRL+SHIFT+DEL
Display the Go To Line dialog box CTRL+G CTRL+G
Increase line indent TAB TAB
Decrease line indent SHIFT+TAB SHIFT+TAB
Make the selected text upper case CTRL+SHIFT+U CTRL+SHIFT+U
Make the selected text lower case CTRL+SHIFT+L CTRL+SHIFT+L
Make the selected text a comment CTRL+K, CTRL+C CTRL+SHIFT+C
Uncomment the selected text CTRL+K, CTRL + U CTRL+SHIFT+R
Open a new query with current connection CTRL+Q CTRL+N
Open database in Object Explorer ALT+F8 ALT+F8
Specify values for template parameters CTRL+SHIFT+M CTRL+SHIFT+M
Execute the selected portion of the query editor or the entire query editor if nothing is selected F5

or

CTRL+E

or

ALT+X

F5

or

CTRL+E

or

ALT+X

Parse the selected portion of the query editor or the entire query editor if nothing is selected CTRL+F5 CTRL+F5
Display the estimated execution plan CTRL+L CTRL+L
Cancel the executing query ALT+BREAK ALT+BREAK
Include actual execution plan in the query output CTRL+M CTRL+K
Open the Query Option dialog box No equivalent CTRL+SHIFT+O
Output results in a grid CTRL+D CTRL+D
Output results in text format CTRL+T CTRL+T
Output results to a file CTRL+SHIFT+F CTRL+SHIFT+F
Show or hide the query results pane CTRL+R CTRL+R
Toggle between query and results pane F6 F6
Move to the next active window in Management Studio CTRL+F6 CTRL+F6
Auto hide all ALT+ENTER No equivalent
Windows CTRL+W No equivalent

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Action Standard SQL Server 2000
Insert a new line ENTER or SHIFT+ENTER ENTER or SHIFT+ENTER
Swap the characters on either side of the cursor CTRL+T No equivalent
Delete on character to the right of the cursor DELETE DELETE
Delete one character to the left of the cursor BACKSPACE

or

SHIFT+

BACKSPACE

BACKSPACE

or

SHIFT+

BACKSPACE

Insert the number of spaces configured for the editor TAB TAB
Insert a blank line above the cursor CTRL+ENTER CTRL+ENTER
Insert a blank line below the cursor CTRL+SHIFT+

ENTER

CTRL+SHIFT+

ENTER

Change the selected text to lowercase CTRL+SHIFT+L CTRL+SHIFT+L
Change the selected text to uppercase CTRL+SHIFT+U CTRL+SHIFT+U
Toggle between insertion mode and overtype mode INSERT INSERT
Move selected lines to the left on tab stop SHIFT+TAB SHIFT+TAB
Delete the word to the right of the cursor CTRL+DELETE CTRL+DELETE
Delete the word to the left of the cursor CTRL+BACKSPACE CTRL+BACKSPACE
Transpose the words on either side of the cursor CTRL+SHIFT+T CTRL+SHIFT+T

 

 

 

 

 

 

 

Note: IntelliSense is not implemented for Transact-SQL editors.

Action Standard SQL Server 2000
List members CTRL+J CTRL+J
Complete word ALT+RIGHT ARROW ALT+RIGHT ARROW

 

Action Standard SQL Server 2000
Toggle full-screen mode SHIFT+ALT+ENTER SHIFT+ALT+ENTER
Move to the next pane of a split pane view of a document F6 F6
Move to the previous document in the editor or designer CTRL+SHIFT+F6

CTRL+SHIFT+TAB

CTRL+SHIFT+F6

CTRL+SHIFT+TAB

Move to the previous pane of a document in split pane view SHIFT+F6 SHIFT+F6
Display the Browser Window CTRL+ALT+R CTRL+ALT+R
Back, display the previous page in the viewing history ALT+LEFTARROW ALT+LEFTARROW
Forward, display the next page in the viewing history ALT+RIGHTARROW ALT+RIGHTARROW

 

 

 

 

Action Standard SQL Server 2000
Display Solution Explorer CTRL+ALT+L CTRL+ALT+L
Display the New File dialog box to create a new file CTRL+N CTRL+SHIFT+INS
Display the New Project dialog box to create a new project CTRL+SHIFT+N CTRL+SHIFT+N
Display the Open File dialog box to open an existing file CTRL+O No equivalent

 

 

Action Standard SQL Server 2000
Help F1 F1
Help on “How Do I” CTRL+F1 CTRL+F1
Books Online Contents CTRL+ALT+F1 CTRL+ALT+F1
Books Online Index CTRL+ALT+F2 CTRL+ALT+F2
Help Search CTRL+ALT+F3 CTRL+ALT+F3
Dynamic Help CTRL+ALT+F4 CTRL+ALT+F4
Help Favorites CTRL+ALT+F CTRL+ALT+F

 

 

Action Standard SQL Server 2000
Display the Find dialog box CTRL+F CTRL+F
Display the Replace dialog box CTRL+H CTRL+H
Start incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search CTRL+I CTRL+B
Find the next occurrence of the previous search text F3 F3
Find the previous occurrence of the search text SHIFT+F3 SHIFT+F3
Find the next occurrence of the currently selected text CTRL+F3 CTRL+F3
Find the previous occurrence of the currently selected text CTRL+SHIFT+F3 CTRL+SHIFT+F3
Display the Replace in Files dialog box CTRL+SHIFT+H CTRL+SHIFT+H
Reverse incremental search so it starts at the bottom of the file and searches to the top CTRL+SHIFT+I CTRL+SHIFT+I
Select or clear the Search up option in Find and Replace ALT+F3, B ALT+F3, B
Stop the Find in Files search ALT+F3, S ALT+F3, S
Select or clear the Find whole word option in Find and Replace ALT+F3, W ALT+F3, W
Selects or clears the Wildcard option in Find and Replace ALT+F3, P ALT+F3, P

 

 

 

 

 

 

Action Standard SQL Server 2000
Cut (delete the currently selected item and place it to the Clipboard) CTRL+X

or

SHIFT+DELETE

CTRL+X

or

SHIFT+DELETE

Copy to the Clipboard CTRL+C

or

CTRL+INSERT

CTRL+C

or

CTRL+INSERT

Paste from the Clipboard at the insertion point CTRL+V

or

SHIFT+INSERT

CTRL+V

or

SHIFT+INSERT

 

 

 

 

Action Standard SQL Server 2000
Refresh F5 F5
Move between the Select logs pane and the Log file summary pane F6 F6
Move to the Log file summary pane ALT+S ALT+S
Load a new log CTRL+SHIFT+L CTRL+SHIFT+L
Export a log CTRL+SHIFT+E CTRL+SHIFT+E
Filter a log CTRL+SHIFT+F CTRL+SHIFT+F
Search in a log CTRL+SHIFT+S CTRL+SHIFT+S

 

 

 

Action Standard SQL Server 2000
Refresh F5 F5
Filter the monitor display CTRL+SHIFT+F CTRL+SHIFT+F

 

Action Standard SQL Server 2000
Refresh F5 F5
Open a detail window from a grid ENTER ENTER

 

Action Standard SQL Server 2000
Define filter F6 F6
Apply filter F7 F7
Show all columns F8 F8

 

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*