SQL Server Management Studio Keyboard Shortcuts
SQL Server Management Studio offers users two keyboard schemes. By default, it uses the Standard scheme, with keyboard shortcuts based on Microsoft Visual Studio. A second scheme, called SQL Server 2000, closely resembles the tools from SQL Server 2000, in particular the keyboard shortcuts from the Query Analyzer. In a few cases, SQL Server Management Studio cannot offer the keyboard shortcuts from Query Analyzer. To change the keyboard scheme or add additional keyboard shortcuts, on the Tools menu, click Options. Select the desired keyboard scheme on the Environment, Keyboard page.
Note
To show only the headings, click Collapse All at the top of this page.
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 |
Windows Management and Toolbar Keyboard Shortcuts
| 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 |
Cursor Movement Keyboard Shortcuts
| 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 |
Text Selection Keyboard Shortcuts
| 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 |
Bookmark Keyboard Shortcuts
| 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 |
Tree Control Keyboard Shortcuts
| 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 |
Code Editor Keyboard Shortcuts
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.
.gif "ms174205.note(en-US,SQL.90).gif")
Note:
The window name is not changed to match the specified file.
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
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
Text Manipulation in Code Editor Keyboard Shortcuts
| 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 |
Microsoft IntelliSense Keyboard Shortcuts
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 |
Document Window and Browser Keyboard Shortcuts
| 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 |
Solution Explorer Keyboard Shortcuts
| 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 |
Help and Books Online Keyboard Shortcuts
| 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 |
Search Keyboard Shortcuts
| 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 |
Cut and Paste Keyboard Shortcuts
| 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 |
Log Viewer Keyboard Shortcuts
| 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 |
Activity Monitor Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
|---|---|---|
Refresh |
F5 |
F5 |
Filter the monitor display |
CTRL+SHIFT+F |
CTRL+SHIFT+F |
Replication Monitor Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
|---|---|---|
Refresh |
F5 |
F5 |
Open a detail window from a grid |
ENTER |
ENTER |
Replication Conflict Viewer Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
|---|---|---|
Define filter |
F6 |
F6 |
Apply filter |
F7 |
F7 |
Show all columns |
F8 |
F8 |
See Also
Concepts
Customizing Menus and Shortcut Keys
Editor Convenience Commands and Features