Home About Us SQL Interview Book Contact Us RSS
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
Articles
Code Snippets
Links
FAQ
Resources

Saravana Kumar
Vinod Kumar


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

So lets get started ....