SQL Server Query analyzer shortcut key set

Source: Internet
Author: User
Tags sql server query
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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.