| 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 |
SQLServer Mgmt Studio 2005
Published on: 10:13:00
No comments:
Post a Comment