SQL Server Shortcut keys enlisted
...
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
|