Interactive SQL provides keyboard shortcuts.
Function | Description |
---|---|
Alt-F4 | Exits Interactive SQL. |
Alt-LEFT ARROW | Displays the previous SQL statement in the history list. |
Alt-RIGHT ARROW | Displays the next SQL statement in the history list |
Ctrl-C | Copies the selected rows 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. |