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+G | 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 |
| Toggle between Object Explorer Details list view and Object Explorer Details property pane. | F6 | No equivalent |
| Control the splitter bar that separates the Object Explorer Details list view and Object Explorer Details property pane to adjust the size of the display pane. | TAB, then UP arrow or DOWN arrow | No equivalent |
| 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 |
| Display the Error List Window (Transact-SQL Editor only) | CRTL+\, CTRL+E | CRTL+\, CTRL+E |
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
| 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 | 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 |
| Open SQL Server Profiler | CTRL+ALT+P | CTRL+ALT+P |
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 (Does not apply to the SQL Editor.) | 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 (Does not apply to the SQL Editor.) | CTRL+SHIFT+T | CTRL+SHIFT+T |
Transact-SQL Debugger Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
|---|---|---|
| Start or continue debugging | ALT+F5 | No equivalent |
| Stop debugging | SHIFT+F5 | No equivalent |
| Step into | F11 | No equivalent |
| Step over | F10 | No equivalent |
| Step out | SHIFT+F11 | No equivalent |
| Implement the Run To Cursor command | CTRL+F10 | No equivalent |
| Display the QuickWatch dialog box | CTRL+ALT+Q | No equivalent |
| Toggle breakpoint | F9 | No equivalent |
| Delete all breakpoints | CTRL+SHIFT+F9 | No equivalent |
| Display the Breakpoints window | CTRL+ALT+B | No equivalent |
| Break all | CTRL+ALT+BREAK | No equivalent |
| Display the Watch 1 window | CTRL+ALT+W, 1 | No equivalent |
| Display the Watch 2 window | CTRL+ALT+W, 2 | No equivalent |
| Display the Watch 3 window | CTRL+ALT+W, 3 | No equivalent |
| Display the Watch 4 window | CTRL+ALT+W, 4 | No equivalent |
| Display the Autos window | CTRL+ALT+V, A | No equivalent |
| Display the Locals window | CTRL+ALT+V, L | No equivalent |
| Display the Immediate window | CTRL+ALT+I | No equivalent |
| Display the Call Stack window | CTRL+ALT+C | No equivalent |
| Display the Threads window | CTRL+ALT+H | No equivalent |
Microsoft IntelliSense Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
|---|---|---|
| List members | CTRL+SPACE or CTRL+J | CTRL+J |
| Complete word | ALT+RIGHT ARROW | ALT+RIGHT ARROW |
| Parameter information | CTRL+SHIFT+SPACE | No equivalent |
| Refresh Local Cache | CTRL+SHIFT+R | No equivalent |
| Jump between syntax pairs | CTRL+] | No equivalent |
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 |
