SQL Server Management Studio Hotkeys - Keyboard Shortcuts
Menu Activation Keyboard Shortcuts
| 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 |
|
|
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 |
|
Select text from the cursor to the end of the document |
SHIFT+ALT+END |
No equivalent |
|
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 |
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 |
||
|
|
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 |
No equivalent |
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 |
Ads
Previous page: Semagic Hotkeys - Keyboard Shortcuts
Next page: Oracle Hotkeys - Keyboard Shortcuts
