SQL Server Query Analyzer shortcut key collection

The following table lists all keyboard shortcuts provided by SQL Server Query Analyzer.

Activity shortcuts

Bookmarks: Clears all bookmarks. Ctrl-shift-f2

Bookmarks: Inserting or deleting a bookmark (toggle). Ctrl+f2

Bookmarks: Moves to the next bookmark. F2 function key

Bookmarks: Moves to the previous bookmark. Shift+f2

Cancel the query. Alt+break

Connection: Connection. Ctrl+o

Connect: Disconnect. Ctrl+f4

Connect: Disconnect and close child windows. Ctrl+f4

Database object information. Alt+f1

EDIT: Clears the Active Editor pane. Ctrl+shift+del

Edit: Comment Code. Ctrl+shift+c

Edit: Copy. You can also use Ctrl+insert. CTRL + C

Edit: Cut. You can also use Shift+del. Ctrl+x

Edit: Reduces indentation. Shift+tab

EDIT: Delete to end of line in Editor pane. Ctrl+del

Edit: Find. Ctrl+f

Edit: Go to line number. Ctrl+g

EDIT: Increases indentation. TAB

Edit: Make the selection lowercase. Ctrl+shift+l

Edit: Make the selection uppercase. Ctrl+shift+u

Edit: Paste. You can also use Shift+insert. CTRL + V

Edit: Deletes a comment. Ctrl+shift+r

Edit: Repeats the last search or find next. F3 function key

EDIT: Replace. Ctrl+h

EDIT: Select All. CTRL + A

Edit: Undo. Ctrl+z

Execute the query. You can also use ctrl+e (for backward compatibility). F5 function key

SQL Query Analyzer Help. F1 function key

Help for the selected Transact-SQL statement. Shift+f1

Browse: Toggles between the query pane and the Results pane. F6 function key

Browsing: Toggles panes. Shift+f6

Browse: Window selector. Ctrl+w

The new Query window. CTRL + N

Object Browser (Show/Hide). F8 function key

Object Search. F4 function key

Parse the query and check the syntax. Ctrl+f5

Print. Ctrl+p

Results: Displays the results in tabular format. Ctrl+d

Results: Displays the results in text format. Ctrl+t

Result: Move the splitter. Ctrl+b

Results: Save the result as a file. Ctrl+shift+f

Results: Displays the Results pane (toggle). Ctrl+r

Save. Ctrl+s

Templates: inserting templates. Ctrl+shift+insert

Templates: Replace template parameters. Ctrl+shift+m

Optimization: Displays the estimated execution plan. Ctrl+l

Optimization: Show execution Plan (toggle on/off). Ctrl+k

Optimization: Index Tuning Wizard. Ctrl+i

Optimization: Displaying customer statistics Ctrl+shift+s

Optimization: Displays server tracking. Ctrl+shift+t

Use the database. Ctrl+u