Query Analyzer is a great tool to have and here are a list of all shortcut keys you can use to speedup your keyboard capabilities to use Query Analyzer.
|
Bookmarks: Clear all bookmarks. |
CTRL-SHIFT-F2 |
|
Bookmarks: Insert or remove a bookmark (toggle). |
CTRL+F2 |
|
Bookmarks: Move to next bookmark. |
F2 |
|
Bookmarks: Move to previous bookmark. |
SHIFT+F2 |
|
Cancel a query. |
ALT+BREAK |
|
Connections: Connect. |
CTRL+O |
|
Connections: Disconnect. |
CTRL+F4 |
|
Connections: Disconnect and close child window. |
CTRL+F4 |
|
Database object information. |
ALT+F1 |
|
Editing: Clear the active Editor pane. |
CTRL+SHIFT+ DEL |
|
Editing: Comment out code. |
CTRL+SHIFT+C |
|
Editing: Copy. You can also use CTRL+INSERT. |
CTRL+C |
|
Editing: Cut. You can also use SHIFT+DEL. |
CTRL+X |
|
Editing: Decrease indent. |
SHIFT+TAB |
|
Editing: Delete through the end of a line in the Editor pane. |
CTRL+DEL |
|
Editing: Find. |
CTRL+F |
|
Editing: Go to a line number. |
CTRL+G |
|
Editing: Increase indent. |
TAB |
|
Editing: Make selection lowercase. |
CTRL+SHIFT+L |
|
Editing: Make selection uppercase. |
CTRL+SHIFT+U |
|
Editing: Paste. You can also use SHIFT+INSERT. |
CTRL+V |
|
Editing: Remove comments. |
CTRL+SHIFT+R |
|
Editing: Repeat last search or find next. |
F3 |
|
Editing: Replace. |
CTRL+H |
|
Editing: Select all. |
CTRL+A |
|
Editing: Undo. |
CTRL+Z |
|
Execute a query. You can also use CTRL+E (for backward compatibility). |
F5 |
|
Help for SQL Query Analyzer. |
F1 |
|
Help for the selected Transact-SQL statement. |
SHIFT+F1 |
|
Navigation: Switch between query and result panes. |
F6 |
|
Navigation: Switch panes. |
Shift+F6 |
|
Navigation: Window Selector. |
CTRL+W |
|
New Query window. |
CTRL+N |
|
Object Browser (show/hide). |
F8 |
|
Object Search. |
F4 |
|
Parse the query and check syntax. |
CTRL+F5 |
|
Print. |
CTRL+P |
|
Results: Display results in grid format. |
CTRL+D |
|
Results: Display results in text format. |
CTRL+T |
|
Results: Move the splitter. |
CTRL+B |
|
Results: Save results to file. |
CTRL+SHIFT+F |
|
Results: Show Results pane (toggle). |
CTRL+R |
|
Save. |
CTRL+S |
|
Templates: Insert a template. |
CTRL+SHIFT+INSERT |
|
Templates: Replace template parameters. |
CTRL+SHIFT+M |
|
Tuning: Display estimated execution plan. |
CTRL+L |
|
Tuning: Display execution plan (toggle ON/OFF). |
CTRL+K |
|
Tuning: Index Tuning Wizard. |
CTRL+I |
|
Tuning: Show client statistics |
CTRL+SHIFT+S |
|
Tuning: Show server trace. |
CTRL+SHIFT+T |
|
Use database. |
CTRL+U |