shortcutmania.com

[ Printable HTML ]    [ Printable PDF ]   


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 Print
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 Print
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


blog comments powered by Disqus