Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-
SQLServer
Mgmt Studio 2005 (2000 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+SHFT+N |
Display the New Project dialog box to create a new project |
|
|
CTRL+SHFT+INS |
Display the Open File dialog box to open an existing
file |
|
|
CTRL+SHFT+Q |
Display the Query Designer |
|
|
ESC |
Close a menu or dialog box, canceling the action |
|
|
|
|||
SQLServer
Mgmt Studio 2005 (2000 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 |
||
|
ALT+F6 |
Move to the next tool window |
||
|
SHFT+ALT+F6 |
Move to the previously selected window |
||
|
CTRL+O |
Opens a new query editor window |
||
|
F8 |
Display Object Explorer |
||
|
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_ALT+R |
Display the Browser Window |
||
|
|
|||
SQLServer
Mgmt Studio 2005 (2000 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 (2000 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 (2000 keyset) Bookmark
Keyboard Shortcuts keyboard shortcuts keys
Shortcut
Command |
|||
|
CTRL+F2 |
Set or remove a bookmark at the current line |
||
|
F2 |
Next bookmark |
||
|
SHFT+F2 |
Previous bookmark |
||
|
CTRL+SHFT+F2 |
Clear bookmarks |
||
|
|
|||
SQLServer
Mgmt Studio 2005 (2000 keyset) Tree Control
Keyboard Shortcuts keyboard shortcuts keys
Shortcut
Command |
|||
|
- (on the 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 (2000 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+BACK SPACE |
Restore the previously undone edit |
||
|
CTRL+SHFT+P |
Insert the body of the specified file into the
current window. Note: The window name is not changed to match the specified
file. |
||
|
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+SHFT+C |
Make the selected text a comment |
||
|
CTRL+SHFT+R |
Uncomment the selected text |
||
|
CTRL+N |
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+K |
Include actual execution plan in the query output |
||
|
CTRL+SHFT+O |
Open the Query Option dialog box |
||
|
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 |
||
|
|
|||
SQLServer
Mgmt Studio 2005 (2000 keyset) Text Manipulation in
Code Editor Keyboard Shortcuts keyboard shortcuts keys
Shortcut
Command |
|||
|
ENTER or SHFT+ENTER |
Insert a new line |
||
|
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 (2000 keyset) Microsoft IntelliSense Keyboard Shortcuts keyboard
shortcuts keys
Shortcut
Command |
|||
|
CTRL+J |
List members |
||
|
ALT+RIGHT ARROW |
Complete word |
||
|
|
|||
SQLServer
Mgmt Studio 2005 (2000 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 (2000 keyset) Solution Explorer
Keyboard Shortcuts keyboard shortcuts keys
Shortcut
Command |
|||
|
CTRL+ALT+L |
Display Solution Explorer |
||
|
CTRL+SHFT+INS |
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 |
||
|
|
|||
SQLServer
Mgmt Studio 2005 (2000 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 (2000 keyset) Search Keyboard
Shortcuts keyboard shortcuts keys
Shortcut
Command |
|||
|
CTRL+F |
Display the Find dialog box |
||
|
CTRL+H |
Display the Replace dialog box |
||
|
CTRL+B |
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 (2000 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 (2000 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 (2000 keyset) Activity Monitor
Keyboard Shortcuts keyboard shortcuts keys
Shortcut
Command |
|||
|
F5 |
Refresh |
||
|
CTRL+SHFT+F |
Filter the monitor display |
||
|
|
|||
SQLServer
Mgmt Studio 2005 (2000 keyset) Replication
Monitor Keyboard Shortcuts keyboard shortcuts keys
Shortcut
Command |
|||
|
F5 |
Refresh |
||
|
ENTER |
Open a detail window from a grid |
||
|
|
|||
SQLServer
Mgmt Studio 2005 (2000 keyset) Replication Conflict
Viewer Keyboard Shortcuts keyboard shortcuts keys
Shortcut
Command |
|||
|
F6 |
Define filter |
||
|
F7 |
Apply filter |
||
|
F8 |
Show all columns |
||
No comments: