SQL Editor is a code editor and explorer for SQL Server databases.
The following is a list of Shortcut keys used in the SQL Editor.
| Shortcut Key | Function |
| F1 | Windows Help File |
| F2 | Toggle Full screen Editor |
| F3 | Find Next Occurrence |
| <SHIFT> <F3> | Find Previous Occurrence |
| F4 | Describe Table, View, Procedure, Function, or Package in popup window |
| F5 | Execute as Script |
| F6 | Toggle between SQL Editor and Results panel |
| F7 | Clear All Text |
| F8 | Recall previous SQL statement |
| F9 | Execute statement |
| <CTRL> F9 | Verify statement without execution (parse) |
| <SHIFT> F9 | Execute current statement at cursor |
| F10 | Popup Menu |
| <CTRL> A | Select All Text |
| <CTRL> C | Copy |
| <CTRL> E | Execute Explain Plan on the Current Statement |
| <CTRL> F | Find Text |
| <CTRL> G | Goto Line |
| <CTRL> L | Converts Text to Lowercase |
| <CTRL> M | Make Code Statement |
| <CTRL> N | Recall Named SQL Statement |
| <CTRL> O | Opens a Text File |
| <CTRL> P | Strip Code Statement |
| <CTRL> R | Find and Replace |
| <CTRL> S | Save File |
| <SHIFT> <CTRL> S | Save File As |
| <CTRL> T | Columns Dropdown |
| <CTRL> U | Converts Text to Uppercase |
| <CTRL> V | Paste |
| <CTRL> X | Cut |
| <CTRL> Z | Undo Last Change |
| <CTRL>. | Display popup list of matching tablenames |
| <SHIFT> <CTRL> Z | Redo Last Undo |
| <ALT> <UP> | Display Previous Statement |
| <ALT> <DOWN> | Display Next Statement (after <ALT> <UP>) |
| <CTRL><HOME> | In the data grids, goes to the top of the recordset |
| <CTRL><END> | In the data grids, goes to the end of the recordset |
| <CTRL><SPACE> | Completely expand dependency tree views |
| <CTRL><TAB> | Cycles through the collection of MDI Child windows |
No comments:
Post a Comment