Keyboard Shortcuts

Interactive SQL provides keyboard shortcuts.

FunctionDescription
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.