Shortcut keys are very important aspects for fast accessing in SQL. Fillowing keys are used as shortsuts in SQL Server.
Description | Shortcuts |
Clear all bookmarks. | CTRL+SHIFT+F2 |
Save All | CTRL+SHIFT+S |
Go To line | CTRL+G |
Display Solution Explorer | CTRL+ALT+L |
Previous Child Window | CTRL+SHIFT+TAB |
Next Child Window | CTRL+TAB |
Full Screen Mode | SHIFT+ALT+ENTER |
Comment a Text | CTRL+K, CTRL+C |
UnComment a Text | CTRL+K,CTRL+U |
Close a menu or Dialog Box | ESC |
Display Query Designer | CTRL+SHIFT+Q |
Display Registered Server | CTRL+ALT+G |
Insert or remove a bookmark (toggle). | CTRL+F2 |
Move to next bookmark. | F2 |
Move to previous bookmark. | SHIFT+F2 |
Cancel a query. | ALT+BREAK |
Connect or Open File. | CTRL+O |
Disconnect Connections. | CTRL+F4 |
Disconnect Connection and close child window. | CTRL+F4 |
Database object information. | ALT+F1 |
Clear the active Editor pane. | CTRL+SHIFT+ DEL |
Comment out code. | CTRL+SHIFT+C |
Copy. You can also use CTRL+INSERT. | CTRL+C |
Cut. You can also use SHIFT+DEL. | CTRL+X |
Decrease indent. | SHIFT+TAB |
Delete through the end of a line in the Editor pane. | CTRL+DEL |
Find. | CTRL+F |
Go to a line number. | CTRL+G |
Increase indent. | TAB |
Make selection lowercase. | CTRL+SHIFT+L |
Make selection uppercase. | CTRL+SHIFT+U |
Paste. You can also use SHIFT+INSERT. | CTRL+V |
Remove comments. | CTRL+SHIFT+R |
Repeat last search or find next. | F3 |
Replace. | CTRL+H |
Select all. | CTRL+A |
Undo. | CTRL+Z |
Execute a query. You can also use CTRL+E. | F5 |
Help for SQL Query Analyzer. | F1 |
Help for the selected Transact-SQL statement. | SHIFT+F1 |
Switch between query and result panes. | F6 |
Switch panes. | SHIFT+F6 |
Window Selector. | CTRL+W |
New Query window or Create new file. | CTRL+N |
Object Explorer (show/hide). | F8 |
Object Search. | F4 |
Parse the query and check syntax. | CTRL+F5 |
Print. | CTRL+P |
Display results in grid format. | CTRL+D |
Display results in text format. | CTRL+T |
Move the splitter. | CTRL+B |
Save results to file. | CTRL+SHIFT+F |
Show Results pane (toggle). | CTRL+R |
Save. | CTRL+S |
Insert a template. | CTRL+SHIFT+INSERT |
Replace template parameters. | CTRL+SHIFT+M |
Display estimated execution plan. | CTRL+L |
Display execution plan (toggle ON/OFF). | CTRL+K |
Index Tuning Wizard. | CTRL+I |
Show client statistics | CTRL+SHIFT+S |
Show server trace. | CTRL+SHIFT+T |
Use database | CTRL+U |
| |
Cancel Executing Query | ALT+BREAK |
Toggle Between Query and Results Pan | F6 |
List members in Intellisense | CTRL+SPACE |
Display Context Menu | SHIFT+F10 |
| |
|
No comments:
Post a Comment