SQL Query Analyzer is a great tool to have and here is a list of all shortcut keys you can use to speed up 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 the 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+
|
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 the 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 pane.
|
F6
|
Navigation: Switch pane.
|
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 a 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
|