List of shortcut keys for SQLServer Mgmt Studio 2005 (Std keyset). Menu Activation Keyboard Shortcuts keyboard shortcuts keys,Windows Management and Toolbar Keyboard Shortcuts keyboard shortcuts keys,Cursor Movement Keyboard Shortcuts keyboard shortcuts keys,Text Selection Keyboard Shortcuts keyboard shortcuts keys,Bookmark Keyboard Shortcuts keyboard shortcuts keys,Tree Control Keyboard Shortcuts keyboard shortcuts keys,Code Editor Keyboard Shortcuts keyboard shortcuts keys,Text Manipulation in Code Editor Keyboard Shortcuts keyboard shortcuts keys,Microsoft IntelliSense Keyboard Shortcuts keyboard shortcuts keys,Document Window and Browser Keyboard Shortcuts keyboard shortcuts keys,Solution Explorer Keyboard Shortcuts keyboard shortcuts keys,Help and Books Online Keyboard Shortcuts keyboard shortcuts keys,Search Keyboard Shortcuts keyboard shortcuts keys,Cut and Paste Keyboard Shortcuts keyboard shortcuts keys,Log Viewer Keyboard Shortcuts keyboard shortcuts keys,Activity Monitor Keyboard Shortcuts keyboard shortcuts keys,Replication Monitor Keyboard Shortcuts keyboard shortcuts keys,Replication Conflict Viewer Keyboard Shortcuts keyboard shortcuts keys
|
SQLServer Mgmt Studio 2005 (Std keyset) Menu Activation Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| ALT | Move to the SQL Server Management Studio menu bar |
|
| ALT+HYPHEN | Activate the menu for a tool component |
|
| SHFT+F10 | Display the context menu |
|
| CTRL+N | Display the New File dialog box to create a file |
|
| CTRL+SHFT+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+SHFT+O | Display the Open Project dialog box to open an existing project |
|
| CTRL+SHFT+A | Display the Add New Item dialog box to add a new file to the current project |
|
| ALT+SHFT+A | Display the Add Existing Item dialog box to add an existing file to the current project |
|
| CTRL+SHFT+Q | Display the Query Designer |
|
| ESC | Close a menu or dialog box, canceling the action |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Windows Management and Toolbar Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| CTRL+F4 | Close the current MDI child window |
|
| CTRL+P | Print |
|
| ALT+F4 | Exit |
|
| SHFT+ALT+ENTER | Toggle full screen mode |
|
| SHFT+ESC | Close the current tool window |
|
| CTRL+TAB | Cycle through the next MDI child windows |
|
| CTRL+SHFT+TAB | Cycle through the previous MDI child windows |
|
| SHFT+ALT | Move to the current tool window toolbar |
|
|
| ALT+F6 | Move to the next tool window |
|
| SHFT+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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Cursor Movement Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| 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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Text Selection Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| CTRL+SHFT+ HOME | Select text from the cursor to the beginning of the document |
|
| CTRL+SHFT+END | Select text from the cursor to the end of the document |
|
| SHFT+HOME | Select text from the cursor to the start of the current line |
|
| SHFT+END | Select text from the cursor to the end of the current line |
|
| SHFT+ DOWN ARROW | Select text down line by line starting from the cursor |
|
| SHFT+UP ARROW | Select text up line by line starting from the cursor |
|
| SHFT+ALT+ UP ARROW | Move the cursor up one line, extending the selection |
|
| SHFT+ PAGE UP | Extend selection up one page |
|
| SHFT+ 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+SHFT+ PAGE UP | Extend the selection to the top of the current window |
|
| CTRL+SHFT+ PAGE DOWN | Move the cursor to the last line in view, extending the selection |
|
| CTRL+SHFT+ RIGHT ARROW | Extend the selection one word to the right |
|
| CTRL+SHFT+ LEFT ARROW | Extend the selection one word to the left |
|
| CTRL+SHFT+ALT+ RIGHT ARROW | Move the cursor to the right one word, extending the selection |
|
| CTRL+SHFT+ALT+ LEFT ARROW | Move the cursor to the left one word, extending the selection |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Bookmark Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| 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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Tree Control Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| - (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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Code Editor Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| SHFT+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+SHFT+Z or CTRL+Y or ALT+SHFT+BACKSPACE | Restore the previously undone edit |
|
| CTRL+S | Save the selected item |
|
| CTRL+SHFT+S | Save all |
|
| CTRL+F4 | Close |
|
| CTRL+P | Print |
|
| ALT+F4 | Exit |
|
| CTRL+SHFT+DEL | Delete all text in the current file |
|
| CTRL+G | Display the Go To Line dialog box |
|
| TAB | Increase line indent |
|
| SHFT+TAB | Decrease line indent |
|
| CTRL+SHFT+U | Make the selected text upper case |
|
| CTRL+SHFT+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+SHFT+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+SHFT+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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Text Manipulation in Code Editor Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| ENTER or SHFT+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 SHFT+ 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+SHFT+ ENTER | Insert a blank line below the cursor |
|
| CTRL+SHFT+L | Change the selected text to lowercase |
|
| CTRL+SHFT+U | Change the selected text to uppercase |
|
| INSERT | Toggle between insertion mode and overtype mode |
|
| SHFT+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+SHFT+T | Transpose the words on either side of the cursor |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Microsoft IntelliSense Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| CTRL+J | List members |
|
| ALT+RIGHT ARROW | Complete word |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Document Window and Browser Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| SHFT+ALT+ENTER | Toggle full-screen mode |
|
| F6 | Move to the next pane of a split pane view of a document |
|
| CTRL+SHFT+F6 CTRL+SHFT+TAB | Move to the previous document in the editor or designer |
|
| SHFT+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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Solution Explorer Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| CTRL+ALT+L | Display Solution Explorer |
|
| CTRL+N | Display the New File dialog box to create a new file |
|
| CTRL+SHFT+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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Help and Books Online Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| 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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Search Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| 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 |
|
| SHFT+F3 | Find the previous occurrence of the search text |
|
| CTRL+F3 | Find the next occurrence of the currently selected text |
|
| CTRL+SHFT+F3 | Find the previous occurrence of the currently selected text |
|
| CTRL+SHFT+H | Display the Replace in Files dialog box |
|
| CTRL+SHFT+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 |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Cut and Paste Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| CTRL+X or SHFT+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 SHFT+INSERT | Paste from the Clipboard at the insertion point |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Log Viewer Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| 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+SHFT+L | Load a new log |
|
| CTRL+SHFT+E | Export a log |
|
| CTRL+SHFT+F | Filter a log |
|
| CTRL+SHFT+S | Search in a log |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Activity Monitor Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| F5 | Refresh |
|
| CTRL+SHFT+F | Filter the monitor display |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Replication Monitor Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| F5 | Refresh |
|
| ENTER | Open a detail window from a grid |
|
| |
|
SQLServer Mgmt Studio 2005 (Std keyset) Replication Conflict Viewer Keyboard Shortcuts keyboard shortcuts keys
Shortcut Command
|
| F6 | Define filter |
|
| F7 | Apply filter |
|
| F8 | Show all columns |
|
No comments:
Post a Comment