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