SQL Server shortcut

Source: Internet
Author: User

SQL Server shortcut

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
Optimized: displays Customer statistics CTRL + Shift + S
Optimized: displays server traces. CTRL + Shift + T
Use the database. CTRL + u

Reprinted from: http://blog.163.com/shn_000/blog/static/171313912009771161433/

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.