I have always googled out for finding any shortcut key to be used in SQL Server that gave me an idea to post this. I have gathered all the SQL Server 2000 and 2005 shortcuts with the help of books online and internet here. Hope this helps you.
SQL Server 2000 Query Analyzer Keys:
|
Shortcut key
|
Description
|
|
CTRL-SHIFT-F2
|
Clear all bookmarks
|
|
CTRL+F2
|
Insert or remove a bookmark (toggle)
|
|
F2
|
Move to next bookmark
|
|
SHIFT+F2
|
Move to previous bookmark
|
|
ALT+BREAK
|
Cancel a query
|
|
CTRL+O
|
Connect
|
|
CTRL+F4
|
Disconnect
|
|
ALT+F4
|
Disconnect and close child window
|
|
ALT+F1
|
Database object information
|
|
CTRL+SHIFT+DEL
|
Clear the active Editor pane
|
|
CTRL+SHIFT+C
|
Comment out code
|
|
CTRL+C or Ctrl+Insert
|
Copy
|
|
CTRL+X or Shift+Del
|
Cut
|
|
SHIFT+TAB
|
Decrease indent
|
|
CTRL+DEL
|
Delete through the end of a line in the Editor pane
|
|
CTRL+F
|
Find
|
|
CTRL+G
|
Go to a line number
|
|
TAB
|
Increase indent
|
|
CTRL+SHIFT+L
|
Make selection lowercase
|
|
CTRL+SHIFT+U
|
Make selection uppercase
|
|
CTRL+V or Shift+Insert
|
Paste
|
|
CTRL+SHIFT+R
|
Remove comments
|
|
F3
|
Repeat last search or find next
|
|
CTRL+H
|
Replace
|
|
CTRL+A
|
Select all
|
|
CTRL+Z
|
Undo
|
|
F5 or Ctrl + E
|
Execute a query
|
|
F1
|
Help for Query Analyzer
|
|
SHIFT+F1
|
Help for the selected Transact-SQL statement
|
|
F6
|
Switch between query and result panes
|
|
Shift+F6
|
Switch panes
|
|
CTRL+W
|
Window Selector
|
|
CTRL+N
|
New Query window
|
|
F8
|
Object Browser (show/hide)
|
|
F4
|
Object Search
|
|
CTRL+F5
|
Parse the query and check syntax
|
|
CTRL+P
|
Print
|
|
CTRL+D
|
Display results in grid format
|
|
CTRL+T
|
Display results in text format
|
|
CTRL+B
|
Move the splitter
|
|
CTRL+SHIFT+F
|
Save results to file
|
|
CTRL+R
|
Show Results pane (toggle)
|
|
CTRL+S
|
Save
|
|
CTRL+SHIFT+INSERT
|
Insert a template
|
|
CTRL+SHIFT+M
|
Replace template parameters
|
|
CTRL+L
|
Display estimated execution plan
|
|
CTRL+K
|
Display execution plan (toggle ON/OFF)
|
|
CTRL+I
|
Index Tuning Wizard
|
|
CTRL+SHIFT+S
|
Show client statistics
|
|
CTRL+SHIFT+T
|
Show server trace
|
|
CTRL+U
|
Use database
|
SQL Server 2005 Management Studio Keys:
SQL Server 2005 Management studio offer two types of key board schema. They are is the Standard Schema and SQL server 2000 schema. You can opt for the keyboard schema by choosing the option that you want in the options menu.
|
Action
|
Standard
|
SQL Server 2000
|
|
Move to the SQL Server Management Studio menu bar
|
ALT
|
ALT
|
|
Activate the menu for a tool component
|
ALT+HYPHEN
|
ALT+HYPHEN
|
|
Display the context menu
|
SHIFT+F10
|
SHIFT+F10
|
|
Display the New File dialog box to create a file
|
CTRL+N
|
No equivalent
|
|
Display the New Project dialog box to create a new project
|
CTRL+SHIFT+N
|
CTRL+SHIFT+N
|
|
Display the Open File dialog box to open an existing file
|
CTRL+O
|
CTRL+SHIFT+INS
|
|
Display the Open Project dialog box to open an existing project
|
CTRL+SHIFT+O
|
No equivalent
|
|
Display the Add New Item dialog box to add a new file to the current project
|
CTRL+SHIFT+A
|
No equivalent
|
|
Display the Add Existing Item dialog box to add an existing file to the current project
|
ALT+SHIFT+A
|
No equivalent
|
|
Display the Query Designer
|
CTRL+SHIFT+Q
|
CTRL+SHIFT+Q
|
|
Close a menu or dialog box, canceling the action
|
ESC
|
ESC
|
Windows Management and Toolbar Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Close the current MDI child window | CTRL+F4 | CTRL+F4 |
| CTRL+P | CTRL+P | |
| Exit | ALT+F4 | ALT+F4 |
| Toggle full screen mode | SHIFT+ALT+ENTER | SHIFT+ALT+ENTER |
| Close the current tool window | SHIFT+ESC | SHIFT+ESC |
| Cycle through the next MDI child windows | CTRL+TAB | CTRL+TAB |
| Cycle through the previous MDI child windows | CTRL+SHIFT+TAB | CTRL+SHIFT+TAB |
| Move to the current tool window toolbar | SHIFT+ALT | No equivalent |
| Move to the next tool window | ALT+F6 | ALT+F6 |
| Move to the previously selected window | SHIFT+ALT+F6 | SHIFT+ALT+F6 |
| Opens a new query editor window | No equivalent | CTRL+O |
| Display Object Explorer | F8 | F8 |
| Display Registered Servers | CTRL+ALT+R | No equivalent |
| Display Template Explorer | CTRL+ALT+T | CTRL+ALT+T |
| Display Solution Explorer | CTRL+ALT+L | CTRL+ALT+L |
| Display the Summary Window | F7 | F7 |
| Display the Properties Window | F4 | F4 |
| Display the Toolbox | CTRL+ALT+X | CTRL+ALT+X |
| Display the Bookmarks Window | CTRL+K, CTRL+W | No equivalent |
| Display the Browser Window | CTRL_ALT+R | CTRL_ALT+R |
Cursor Movement Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Move the cursor left | LEFT ARROW | LEFT ARROW |
| Move the cursor right | RIGHT ARROW | RIGHT ARROW |
| Move the cursor up | UP ARROW | UP ARROW |
| Move the cursor down | DOWN ARROW | DOWN ARROW |
| Move the cursor to the beginning of the line | HOME | HOME |
| Move the cursor to the end of the line | END | END |
| Move the cursor to the beginning of the document | CTRL+HOME | CTRL+HOME |
| Move the cursor to the end of the document | CTRL+END | CTRL+END |
| Move the cursor up one screen | PAGE UP | PAGE UP |
| Move the cursor down one screen | PAGE DOWN | PAGE DOWN |
| Moves the cursor one word to the right | CTRL+ RIGHT ARROW | CTRL+RIGHT ARROW |
| Moves the cursor one word to the left | CTRL+LEFT ARROW | CTRL+LEFT ARROW |
Text Selection Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Select text from the cursor to the beginning of the document | CTRL+SHIFT+HOME | CTRL+SHIFT+HOME |
| Select text from the cursor to the end of the document | CTRL+SHIFT+END | CTRL+SHIFT+END |
| Select text from the cursor to the start of the current line | SHIFT+HOME | SHIFT+HOME |
| Select text from the cursor to the end of the current line | SHIFT+END | SHIFT+END |
| Select text down line by line starting from the cursor | SHIFT+DOWN ARROW | SHIFT+DOWN ARROW |
| Select text up line by line starting from the cursor | SHIFT+UP ARROW | SHIFT+UP ARROW |
| Move the cursor up one line, extending the selection | SHIFT+ALT+UP ARROW | SHIFT+ALT+UP ARROW |
| Extend selection up one page | SHIFT+PAGE UP | SHIFT+PAGE UP |
| Extend selection down one page | SHIFT+PAGE DOWN | SHIFT+PAGE DOWN |
| Select the entire current document | CTRL+A | CTRL+A |
| Select the word containing the cursor, or the closest word | CTRL+W | CTRL+W |
| Select the current location in the editor, back to the previous location in the editor | CTRL+= | CTRL+= |
| Extend the selection to the top of the current window | CTRL+SHIFT+PAGE UP | CTRL+SHIFT+PAGE UP |
| Move the cursor to the last line in view, extending the selection | CTRL+SHIFT+PAGE DOWN | CTRL+SHIFT+PAGE DOWN |
| Extend the selection one word to the right | CTRL+SHIFT+
RIGHT ARROW |
CTRL+SHIFT+
RIGHT ARROW |
| Extend the selection one word to the left | CTRL+SHIFT+LEFT ARROW | CTRL+SHIFT+
LEFT ARROW |
| Move the cursor to the right one word, extending the selection | CTRL+SHIFT+ALT+RIGHT ARROW | CTRL+SHIFT+ALT+RIGHT ARROW |
| Move the cursor to the left one word, extending the selection | CTRL+SHIFT+ALT+LEFT ARROW | CTRL+SHIFT+ALT+LEFT ARROW |
Bookmark Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Set or remove a bookmark at the current line | CTRL+K, CTRL+K | CTRL+F2 |
| Next bookmark | CTRL+K, CTRL+N | F2 |
| Previous bookmark | CTRL+K, CTRL+P | SHIFT+F2 |
| Clear bookmarks | CTRL+K, CTRL+L | CTRL+SHIFT+F2 |
Tree Control Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Collapse tree nodes | – (on the numeric keypad) | – (on the numeric keypad) |
| Expand all tree nodes | * (on the numeric keypad) | * (on the numeric keypad) |
| Scroll the tree control up in the window | CTRL+UP ARROW | CTRL+UP ARROW |
| Scroll the tree control down in the window | CTRL+ DOWN ARROW | CTRL+ DOWN ARROW |
Code Editor Keyboard Shortcuts
Note: All shortcuts are not implemented in all types of code editors.
| Action | Standard | SQL Server 2000 |
| Toggle the full-screen display | SHIFT+ALT+ENTER | SHIFT+ALT+ENTER |
| Scroll text up one line | CTRL+UP ARROW | CTRL+UP ARROW |
| Scroll text down one line | CTRL+
DOWN ARROW |
CTRL+
DOWN ARROW |
| Reverse the last editing action | CTRL+Z | CTRL+Z |
| Restore the previously undone edit | CTRL+SHIFT+Z
or CTRL+Y or ALT+SHIFT+BACKSPACE |
CTRL+SHIFT+Z
or CTRL+Y or ALT+SHIFT+BACK SPACE |
| Insert the body of the specified file into the current window. | No equivalent | CTRL+SHIFT+P |
| Save the selected item | CTRL+S | CTRL+S |
| Save all | CTRL+SHIFT+S | CTRL+SHIFT+S |
| Close | CTRL+F4 | CTRL+F4 |
| CTRL+P | CTRL+P | |
| Exit | ALT+F4 | ALT+F4 |
| Delete all text in the current file | CTRL+SHIFT+DEL | CTRL+SHIFT+DEL |
| Display the Go To Line dialog box | CTRL+G | CTRL+G |
| Increase line indent | TAB | TAB |
| Decrease line indent | SHIFT+TAB | SHIFT+TAB |
| Make the selected text upper case | CTRL+SHIFT+U | CTRL+SHIFT+U |
| Make the selected text lower case | CTRL+SHIFT+L | CTRL+SHIFT+L |
| Make the selected text a comment | CTRL+K, CTRL+C | CTRL+SHIFT+C |
| Uncomment the selected text | CTRL+K, CTRL + U | CTRL+SHIFT+R |
| Open a new query with current connection | CTRL+Q | CTRL+N |
| Open database in Object Explorer | ALT+F8 | ALT+F8 |
| Specify values for template parameters | CTRL+SHIFT+M | CTRL+SHIFT+M |
| Execute the selected portion of the query editor or the entire query editor if nothing is selected | F5
or CTRL+E or ALT+X |
F5
or CTRL+E or ALT+X |
| Parse the selected portion of the query editor or the entire query editor if nothing is selected | CTRL+F5 | CTRL+F5 |
| Display the estimated execution plan | CTRL+L | CTRL+L |
| Cancel the executing query | ALT+BREAK | ALT+BREAK |
| Include actual execution plan in the query output | CTRL+M | CTRL+K |
| Open the Query Option dialog box | No equivalent | CTRL+SHIFT+O |
| Output results in a grid | CTRL+D | CTRL+D |
| Output results in text format | CTRL+T | CTRL+T |
| Output results to a file | CTRL+SHIFT+F | CTRL+SHIFT+F |
| Show or hide the query results pane | CTRL+R | CTRL+R |
| Toggle between query and results pane | F6 | F6 |
| Move to the next active window in Management Studio | CTRL+F6 | CTRL+F6 |
| Auto hide all | ALT+ENTER | No equivalent |
| Windows | CTRL+W | No equivalent |
Text Manipulation in Code Editor Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Insert a new line | ENTER or SHIFT+ENTER | ENTER or SHIFT+ENTER |
| Swap the characters on either side of the cursor | CTRL+T | No equivalent |
| Delete on character to the right of the cursor | DELETE | DELETE |
| Delete one character to the left of the cursor | BACKSPACE
or SHIFT+ BACKSPACE |
BACKSPACE
or SHIFT+ BACKSPACE |
| Insert the number of spaces configured for the editor | TAB | TAB |
| Insert a blank line above the cursor | CTRL+ENTER | CTRL+ENTER |
| Insert a blank line below the cursor | CTRL+SHIFT+
ENTER |
CTRL+SHIFT+
ENTER |
| Change the selected text to lowercase | CTRL+SHIFT+L | CTRL+SHIFT+L |
| Change the selected text to uppercase | CTRL+SHIFT+U | CTRL+SHIFT+U |
| Toggle between insertion mode and overtype mode | INSERT | INSERT |
| Move selected lines to the left on tab stop | SHIFT+TAB | SHIFT+TAB |
| Delete the word to the right of the cursor | CTRL+DELETE | CTRL+DELETE |
| Delete the word to the left of the cursor | CTRL+BACKSPACE | CTRL+BACKSPACE |
| Transpose the words on either side of the cursor | CTRL+SHIFT+T | CTRL+SHIFT+T |
Microsoft IntelliSense Keyboard Shortcuts
Note: IntelliSense is not implemented for Transact-SQL editors.
| Action | Standard | SQL Server 2000 |
| List members | CTRL+J | CTRL+J |
| Complete word | ALT+RIGHT ARROW | ALT+RIGHT ARROW |
Document Window and Browser Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Toggle full-screen mode | SHIFT+ALT+ENTER | SHIFT+ALT+ENTER |
| Move to the next pane of a split pane view of a document | F6 | F6 |
| Move to the previous document in the editor or designer | CTRL+SHIFT+F6
CTRL+SHIFT+TAB |
CTRL+SHIFT+F6
CTRL+SHIFT+TAB |
| Move to the previous pane of a document in split pane view | SHIFT+F6 | SHIFT+F6 |
| Display the Browser Window | CTRL+ALT+R | CTRL+ALT+R |
| Back, display the previous page in the viewing history | ALT+LEFTARROW | ALT+LEFTARROW |
| Forward, display the next page in the viewing history | ALT+RIGHTARROW | ALT+RIGHTARROW |
Solution Explorer Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Display Solution Explorer | CTRL+ALT+L | CTRL+ALT+L |
| Display the New File dialog box to create a new file | CTRL+N | CTRL+SHIFT+INS |
| Display the New Project dialog box to create a new project | CTRL+SHIFT+N | CTRL+SHIFT+N |
| Display the Open File dialog box to open an existing file | CTRL+O | No equivalent |
Help and Books Online Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Help | F1 | F1 |
| Help on “How Do I” | CTRL+F1 | CTRL+F1 |
| Books Online Contents | CTRL+ALT+F1 | CTRL+ALT+F1 |
| Books Online Index | CTRL+ALT+F2 | CTRL+ALT+F2 |
| Help Search | CTRL+ALT+F3 | CTRL+ALT+F3 |
| Dynamic Help | CTRL+ALT+F4 | CTRL+ALT+F4 |
| Help Favorites | CTRL+ALT+F | CTRL+ALT+F |
Search Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Display the Find dialog box | CTRL+F | CTRL+F |
| Display the Replace dialog box | CTRL+H | CTRL+H |
| Start incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search | CTRL+I | CTRL+B |
| Find the next occurrence of the previous search text | F3 | F3 |
| Find the previous occurrence of the search text | SHIFT+F3 | SHIFT+F3 |
| Find the next occurrence of the currently selected text | CTRL+F3 | CTRL+F3 |
| Find the previous occurrence of the currently selected text | CTRL+SHIFT+F3 | CTRL+SHIFT+F3 |
| Display the Replace in Files dialog box | CTRL+SHIFT+H | CTRL+SHIFT+H |
| Reverse incremental search so it starts at the bottom of the file and searches to the top | CTRL+SHIFT+I | CTRL+SHIFT+I |
| Select or clear the Search up option in Find and Replace | ALT+F3, B | ALT+F3, B |
| Stop the Find in Files search | ALT+F3, S | ALT+F3, S |
| Select or clear the Find whole word option in Find and Replace | ALT+F3, W | ALT+F3, W |
| Selects or clears the Wildcard option in Find and Replace | ALT+F3, P | ALT+F3, P |
Cut and Paste Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Cut (delete the currently selected item and place it to the Clipboard) | CTRL+X
or SHIFT+DELETE |
CTRL+X
or SHIFT+DELETE |
| Copy to the Clipboard | CTRL+C
or CTRL+INSERT |
CTRL+C
or CTRL+INSERT |
| Paste from the Clipboard at the insertion point | CTRL+V
or SHIFT+INSERT |
CTRL+V
or SHIFT+INSERT |
Log Viewer Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Refresh | F5 | F5 |
| Move between the Select logs pane and the Log file summary pane | F6 | F6 |
| Move to the Log file summary pane | ALT+S | ALT+S |
| Load a new log | CTRL+SHIFT+L | CTRL+SHIFT+L |
| Export a log | CTRL+SHIFT+E | CTRL+SHIFT+E |
| Filter a log | CTRL+SHIFT+F | CTRL+SHIFT+F |
| Search in a log | CTRL+SHIFT+S | CTRL+SHIFT+S |
Activity Monitor Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Refresh | F5 | F5 |
| Filter the monitor display | CTRL+SHIFT+F | CTRL+SHIFT+F |
Replication Monitor Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Refresh | F5 | F5 |
| Open a detail window from a grid | ENTER | ENTER |
Replication Conflict Viewer Keyboard Shortcuts
| Action | Standard | SQL Server 2000 |
| Define filter | F6 | F6 |
| Apply filter | F7 | F7 |
| Show all columns | F8 | F8 |
Leave a Reply