SQL Server Query analyzer shortcut key set

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

Activity shortcuts

Bookmarks: Clear all bookmarks. CTRL-SHIFT-F2

Bookmarks: insert or delete bookmarks (switch ). CTRL + F2

Bookmarks: Move to the next bookmarks. F2 function key

Bookmarks: Move to the previous bookmarks. SHIFT + F2

Cancel query. ALT + BREAK

Connection: connection. CTRL + O

Connection: disconnect. CTRL + F4

Connection: disconnect and close the subwindow. CTRL + F4

Database object information. ALT + F1

Edit: Clear the editor pane of the activity. CTRL + SHIFT + DEL

Edit: annotate the 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: reduce indentation. SHIFT + TAB

Edit: Delete to the end of a row in the editor pane. CTRL + DEL

Edit: search. CTRL + F

Edit: Go to the row number. CTRL + G

Edit: Increase indentation. TAB

Edit: Make the selected content lowercase. CTRL + SHIFT + L

Edit: Make the selected content in uppercase. CTRL + SHIFT + U

Edit: paste. You can also use SHIFT + INSERT. CTRL + V

Edit: Delete the comment. CTRL + SHIFT + R

Edit: Repeat the previous search or find the next one. F3 function key

Edit: replace. CTRL + H

Edit: Select All. CTRL +
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: switch between the query pane and the result pane. F6 function key

Browse: Switch pane. Shift + F6

Browser: Window selector. CTRL + W

"New query" window. CTRL + N

Object Browser (display/hide ). F8 function key

Object Search. F4 function key

Analyze the query and check the syntax. CTRL + F5

Print. CTRL + P

Result: The result is displayed in table format. CTRL + D

Result: The result is displayed in text format. CTRL + T

Result: The splitter is moved. CTRL + B

Result: Save the result as a file. CTRL + SHIFT + F

Result: The result pane is displayed (switch ). CTRL + R

Save. CTRL + S

Template: insert template. CTRL + SHIFT + INSERT

Template: Replace the template parameters. CTRL + SHIFT + M

Optimization: displays the estimated execution plan. CTRL + L

Optimization: displays the Execution Plan (switch ON/OFF ). CTRL + K

Optimization: Index Optimization Wizard. CTRL + I

Optimization: Display Customer statistics Ctrl + Shift + S

Optimized: displays server traces. CTRL + Shift + T

Use the database. CTRL + u