Interactive SQL provides the following keyboard shortcuts.
Function |
Description |
|---|---|
ALT+F4 |
Exits Interactive SQL. |
ALT+LEFT CURSOR |
Displays the previous SQL statement in the history list. |
ALT+RIGHT CURSOR |
Displays the next SQL statement in the history list |
CTRL+C |
Copies the selected row(s) and column headings to the clipboard. |
CTRL+END |
Moves to the bottom of the current pane. |
CTRL+F6 |
Cycles through the open Interactive SQL windows. |
CTRL+H |
Displays the history of your executed SQL statements during the current session. |
CTRL+HOME |
Moves to the top of the current pane. |
CTRL+N |
Clears the contents of the Interactive SQL window. |
CTRL+Q |
Displays the Query Editor, which helps you build SQL queries. When you have finished building your query, click OK to export it back into the SQL Statements pane. |
CTRL+S |
Saves the contents of the SQL Statements pane. |
SHIFT+F5 |
Refreshes the plan without executing the statement in the SQL Statements pane. This allows you to see the plan for a statement without altering table data. |
ESC |
Clears the SQL Statements pane. |
F2 |
Allows you to edit the selected row in the result set. You can use the Tab key to move from column to column within the row. |
F5 |
Executes all text in the SQL Statements pane. You can also perform this operation by clicking the Execute SQL Statement button on the toolbar. |
F7 |
Displays the Lookup Table Name dialog. In this dialog, you can find and select a table and then press Enter to insert the table name into the SQL Statements pane at the cursor position. Or, with a table selected in the list, press F7 again to display the columns in that table. You can then select a column and press Enter to insert the column name into the SQL Statements pane at the cursor position. |
F8 |
Displays the Lookup Procedure Name dialog. In this dialog, you can find and select a procedure, then press Enter to insert the procedure name into the SQL Statements pane at the cursor position. |
F9 |
Executes the selected text in the SQL Statements pane. If no text is selected, all of the statements are executed. |
Page down |
Moves down in the current pane. |
Page up |
Moves up in the current pane. |
