Sunday, July 12, 2009

SQL Editor Shortcut Keys

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