| Activity Monitor Keyboard Shortcuts
|
| CTRL+SHIFT+F | |
Filter the monitor display |
|
| F5 | |
Refresh |
|
| Bookmark Keyboard Shortcuts
|
| CTRL+K, CTRL+K | |
Set or remove a bookmark at the current line |
|
| CTRL+K, CTRL+L | |
Clear bookmarks |
|
| CTRL+K, CTRL+N | |
Next bookmark |
|
| CTRL+K, CTRL+P | |
Previous bookmark |
|
| Code Editor Keyboard Shortcuts
|
| ALT+BREAK | |
Cancel the executing query |
|
| ALT+ENTER | |
Auto hide all |
|
| CTRL+D | |
Output results in a grid |
|
| CTRL+F5 | |
Parse the selected portion of the query editor or the entire query editor if nothing is selected |
|
| CTRL+F6 | |
Move to the next active window in Management Studio |
|
| CTRL+L | |
Display the estimated execution plan |
|
| CTRL+M | |
Include actual execution plan in the query output |
|
| CTRL+R | |
Show or hide the query results pane |
|
| CTRL+SHIFT+F | |
Output results to a file |
|
| CTRL+T | |
Output results in text format |
|
| CTRL+W | |
Windows |
|
| F6 | |
Toggle between query and results pane |
|
| No equivalent | |
Open the Query Option dialog box |
|
| Code Editor Keyboard Shortcuts (All shortcuts are not implemented in all types of code editors.)
|
| ALT+F4 | |
Exit |
|
| ALT+F8 | |
Open database in Object Explorer |
|
| CTRL+DOWN ARROW | |
Scroll text down one line |
|
| CTRL+F4 | |
Close |
|
| CTRL+G | |
Display the Go To Line dialog box |
|
| CTRL+K, CTRL + U | |
Uncomment the selected text |
|
| CTRL+K, CTRL+C | |
Make the selected text a comment |
|
| CTRL+P | |
Print |
|
| CTRL+Q | |
Open a new query with current connection |
|
| CTRL+S | |
Save the selected item |
|
| CTRL+SHIFT+DEL | |
Delete all text in the current file |
|
| CTRL+SHIFT+L | |
Make the selected text lower case |
|
| CTRL+SHIFT+M | |
Specify values for template parameters |
|
| CTRL+SHIFT+S | |
Save all |
|
| CTRL+SHIFT+U | |
Make the selected text upper case |
|
| CTRL+SHIFT+Z or CTRL+Y or ALT+SHIFT+BACKSPACE | |
Restore the previously undone edit |
|
| CTRL+UP ARROW | |
Scroll text up one line |
|
| CTRL+Z | |
Reverse the last editing action |
|
| F5 or CTRL+E or ALT+X | |
Execute the selected portion of the query editor or the entire query editor if nothing is selected |
|
| No equivalent | |
Insert the body of the specified file into the current window. Note: The window name is not changed to match the specified file. |
|
| SHIFT+ALT+ENTER | |
Toggle the full-screen display |
|
| SHIFT+TAB | |
Decrease line indent |
|
| TAB | |
Increase line indent |
|
| Cursor Movement Keyboard Shortcuts
|
| CTRL+END | |
Move the cursor to the end of the document |
|
| CTRL+HOME | |
Move the cursor to the beginning of the document |
|
| CTRL+LEFT ARROW | |
Moves the cursor one word to the left |
|
| CTRL+RIGHT ARROW | |
Moves the cursor one word to the right |
|
| DOWN ARROW | |
Move the cursor down |
|
| END | |
Move the cursor to the end of the line |
|
| HOME | |
Move the cursor to the beginning of the line |
|
| LEFT ARROW | |
Move the cursor left |
|
| PAGE DOWN | |
Move the cursor down one screen |
|
| PAGE UP | |
Move the cursor up one screen |
|
| RIGHT ARROW | |
Move the cursor right |
|
| UP ARROW | |
Move the cursor up |
|
| Cut and Paste Keyboard Shortcuts
|
| CTRL+C or CTRL+INSERT | |
Copy to the Clipboard |
|
| CTRL+V or SHIFT+INSERT | |
Paste from the Clipboard at the insertion point |
|
| CTRL+X or SHIFT+DELETE | |
Cut (delete the currently selected item and place it to the Clipboard) |
|
| Document Window and Browser Keyboard Shortcuts
|
| ALT+LEFTARROW | |
Back, display the previous page in the viewing history |
|
| ALT+RIGHTARROW | |
Forward, display the next page in the viewing history |
|
| CTRL+ALT+R | |
Display the Browser Window |
|
| CTRL+SHIFT+F6 | |
Move to the previous document in the editor or designer |
|
| F6 | |
Move to the next pane of a split pane view of a document |
|
| SHIFT+ALT+ENTER | |
Toggle full-screen mode |
|
| SHIFT+F6 | |
Move to the previous pane of a document in split pane view |
|
| Help and Books Online Keyboard Shortcuts
|
| CTRL+ALT+F | |
Help Favorites |
|
| CTRL+ALT+F1 | |
Books Online Contents |
|
| CTRL+ALT+F2 | |
Books Online Index |
|
| CTRL+ALT+F3 | |
Help Search |
|
| CTRL+ALT+F4 | |
Dynamic Help |
|
| CTRL+F1 | |
Help on "How Do I" |
|
| F1 | |
Help |
|
| Log Viewer Keyboard Shortcuts
|
| ALT+S | |
Move to the Log file summary pane |
|
| CTRL+SHIFT+E | |
Export a log |
|
| CTRL+SHIFT+F | |
Filter a log |
|
| CTRL+SHIFT+L | |
Load a new log |
|
| CTRL+SHIFT+S | |
Search in a log |
|
| F5 | |
Refresh |
|
| F6 | |
Move between the Select logs pane and the Log file summary pane |
|
| Menu Activation Keyboard Shortcuts
|
| ALT | |
Move to the SQL Server Management Studio menu bar |
|
| ALT+HYPHEN | |
Activate the menu for a tool component |
|
| ALT+SHIFT+A | |
Display the Add Existing Item dialog box to add an existing file to the current project |
|
| CTRL+N | |
Display the New File dialog box to create a file |
|
| CTRL+O | |
Display the Open File dialog box to open an existing file |
|
| CTRL+SHIFT+A | |
Display the Add New Item dialog box to add a new file to the current project |
|
| CTRL+SHIFT+N | |
Display the New Project dialog box to create a new project |
|
| CTRL+SHIFT+O | |
Display the Open Project dialog box to open an existing project |
|
| CTRL+SHIFT+Q | |
Display the Query Designer |
|
| ESC | |
Close a menu or dialog box, canceling the action |
|
| SHIFT+F10 | |
Display the context menu |
|
| Microsoft IntelliSense Keyboard Shortcuts
|
| ALT+RIGHT ARROW | |
Complete word |
|
| CTRL+J | |
List members |
|
| Replication Conflict Viewer Keyboard Shortcuts
|
| F6 | |
Define filter |
|
| F7 | |
Apply filter |
|
| F8 | |
Show all columns |
|
| Replication Monitor Keyboard Shortcuts
|
| ENTER | |
Open a detail window from a grid |
|
| F5 | |
Refresh |
|
| Search Keyboard Shortcuts
|
| ALT+F3, B | |
Select or clear the Search up option in Find and Replace |
|
| ALT+F3, P | |
Selects or clears the Wildcard option in Find and Replace |
|
| ALT+F3, S | |
Stop the Find in Files search |
|
| ALT+F3, W | |
Select or clear the Find whole word option in Find and Replace |
|
| CTRL+F | |
Display the Find dialog box |
|
| CTRL+F3 | |
Find the next occurrence of the currently selected text |
|
| CTRL+H | |
Display the Replace dialog box |
|
| CTRL+I | |
Start incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search |
|
| CTRL+SHIFT+F3 | |
Find the previous occurrence of the currently selected text |
|
| CTRL+SHIFT+H | |
Display the Replace in Files dialog box |
|
| CTRL+SHIFT+I | |
Reverse incremental search so it starts at the bottom of the file and searches to the top |
|
| F3 | |
Find the next occurrence of the previous search text |
|
| SHIFT+F3 | |
Find the previous occurrence of the search text |
|
| Solution Explorer Keyboard Shortcuts
|
| CTRL+ALT+L | |
Display Solution Explorer |
|
| CTRL+N | |
Display the New File dialog box to create a new file |
|
| CTRL+O | |
Display the Open File dialog box to open an existing file |
|
| CTRL+SHIFT+N | |
Display the New Project dialog box to create a new project |
|
| Text Manipulation in Code Editor Keyboard Shortcuts
|
| BACKSPACE or SHIFT+BACKSPACE | |
Delete one character to the left of the cursor |
|
| CTRL+BACKSPACE | |
Delete the word to the left of the cursor |
|
| CTRL+DELETE | |
Delete the word to the right of the cursor |
|
| CTRL+ENTER | |
Insert a blank line above the cursor |
|
| CTRL+SHIFT+ENTER | |
Insert a blank line below the cursor |
|
| CTRL+SHIFT+L | |
Change the selected text to lowercase |
|
| CTRL+SHIFT+T | |
Transpose the words on either side of the cursor |
|
| CTRL+SHIFT+U | |
Change the selected text to uppercase |
|
| CTRL+T | |
Swap the characters on either side of the cursor |
|
| DELETE | |
Delete on character to the right of the cursor |
|
| ENTER or SHIFT+ENTER | |
Insert a new line |
|
| INSERT | |
Toggle between insertion mode and overtype mode |
|
| SHIFT+TAB | |
Move selected lines to the left on tab stop |
|
| TAB | |
Insert the number of spaces configured for the editor |
|
| Text Selection Keyboard Shortcuts
|
| CTRL+= | |
Select the current location in the editor, back to the previous location in the editor |
|
| CTRL+A | |
Select the entire current document |
|
| CTRL+SHIFT+ALT+LEFT ARROW | |
Move the cursor to the left one word, extending the selection |
|
| CTRL+SHIFT+ALT+RIGHT ARROW | |
Move the cursor to the right one word, extending the selection |
|
| CTRL+SHIFT+END | |
Select text from the cursor to the end of the document |
|
| CTRL+SHIFT+HOME | |
Select text from the cursor to the beginning of the document |
|
| CTRL+SHIFT+LEFT ARROW | |
Extend the selection one word to the left |
|
| CTRL+SHIFT+PAGE DOWN | |
Move the cursor to the last line in view, extending the selection |
|
| CTRL+SHIFT+PAGE UP | |
Extend the selection to the top of the current window |
|
| CTRL+SHIFT+RIGHT ARROW | |
Extend the selection one word to the right |
|
| CTRL+W | |
Select the word containing the cursor, or the closest word |
|
| SHIFT+ALT+UP ARROW | |
Move the cursor up one line, extending the selection |
|
| SHIFT+DOWN ARROW | |
Select text down line by line starting from the cursor |
|
| SHIFT+END | |
Select text from the cursor to the end of the current line |
|
| SHIFT+HOME | |
Select text from the cursor to the start of the current line |
|
| SHIFT+PAGE DOWN | |
Extend selection down one page |
|
| SHIFT+PAGE UP | |
Extend selection up one page |
|
| SHIFT+UP ARROW | |
Select text up line by line starting from the cursor |
|
| Tree Control Keyboard Shortcuts
|
| - (on the numeric keypad) | |
Collapse tree nodes |
|
| * (on the numeric keypad) | |
Expand all tree nodes |
|
| CTRL+ DOWN ARROW | |
Scroll the tree control down in the window |
|
| CTRL+UP ARROW | |
Scroll the tree control up in the window |
|
| Windows Management and Toolbar Keyboard Shortcuts
|
| ALT+F4 | |
Exit |
|
| ALT+F6 | |
Move to the next tool window |
|
| CTRL_ALT+R | |
Display the Browser Window |
|
| CTRL+ALT+L | |
Display Solution Explorer |
|
| CTRL+ALT+R | |
Display Registered Servers |
|
| CTRL+ALT+T | |
Display Template Explorer |
|
| CTRL+ALT+X | |
Display the Toolbox |
|
| CTRL+F4 | |
Close the current MDI child window |
|
| CTRL+K, CTRL+W | |
Display the Bookmarks Window |
|
| CTRL+P | |
Print |
|
| CTRL+SHIFT+TAB | |
Cycle through the previous MDI child windows |
|
| CTRL+TAB | |
Cycle through the next MDI child windows |
|
| F4 | |
Display the Properties Window |
|
| F7 | |
Display the Summary Window |
|
| F8 | |
Display Object Explorer |
|
| No equivalent | |
Opens a new query editor window |
|
| SHIFT+ALT | |
Move to the current tool window toolbar |
|
| SHIFT+ALT+ENTER | |
Toggle full screen mode |
|
| SHIFT+ALT+F6 | |
Move to the previously selected window |
|
| SHIFT+ESC | |
Close the current tool window |
|