Alt+F4

Alt+Left Arrow

On Mac OS X, use Control Command+Left Arrow.

Alt+Right Arrow

On Mac OS X, use Control Command+Right Arrow.

Selects all text in the active pane.

In the Results pane, if the results are not the entire result set, you are prompted to fetch the remaining rows. Otherwise the currently fetched results are selected. See Copying columns, rows, and cells from an Interactive SQL result set.

In the Results pane, copies the selected row(s) and column headings to the clipboard.

In the SQL Statements pane, copies the selected text to the clipboard.

Displays a popup menu for a cell that has focus in a result set in the Results tab.

This keyboard shortcut is an alternative to clicking ... within a table cell.

Ctrl+H

On Mac OS X, use Control Command+H.

Opens the Query Editor.

The Query Editor helps you build SQL queries. When you have finished building your query, click OK to export it back into the SQL Statements pane.

Adds and removes the double-hyphen (--) SQL comment indicator.

To turn existing text into comments, select the text in the SQL Statements pane and press Ctrl+minus sign. The SQL comment indicator is added to the beginning of each line in the selection.

If no text is selected, the comment indicator is added to the beginning of the current line.

To remove a comment indicator, select the text and press Ctrl+minus sign.

See Comments.

Adds and removes the double-slash (//) SQL comment indicator.

To turn existing text into comments, select the text in the SQL Statements pane and press Ctrl+forward slash. The SQL comment indicator is added to the beginning of each line in the selection.

If no text is selected, the comment indicator is added to the beginning of the current line.

To remove a comment indicator, select the text and press Ctrl+forward slash.

See Comments.

Increases the line indentation of selected text in the SQL Statements pane.

If no text is selected, the indentation is applied to the current line.

You can change the number of spaces that are indented. Alternatively, click Tools » Options » Editor » Tabs.

Decreases line indentation of selected text in the SQL Statements pane.

If no text is selected, the indentation is applied to the current line.

You can change the number of spaces that are indented. Alternatively, click Tools » Options » Editor » Tabs.

By default, pressing the Esc key has no affect.

However, you can set the Esc key to clear the SQL Statements pane and close any opened result sets. Click Tools » Options » Compatibility and click ESCAPE key Clears SQL Statements And Closes Result Sets.

Executes all text in the SQL Statements pane.

You can also perform this operation by clicking Execute All SQL Statements on the toolbar or by clicking SQL » Execute.

Displays the Lookup Table Name window.

In this window, 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.

Displays the Lookup Procedure Name window.

In this window, you can find and select a procedure and then press Enter to insert the procedure name into the SQL Statements pane at the cursor position.

Executes the text that is selected in the SQL Statements pane.

If no text is selected, all the statements are executed.

You can also perform this operation by clicking Execute Selected Statements on the toolbar or by clicking SQL » Execute.

Executes the selected SQL statement, and then selects the next statement. This shortcut allows you to step through a series of SQL statements. See Executing SQL statements in Interactive SQL.

Displays the shortcut menu for the area that has focus.

This keyboard shortcut is an alternative to right-clicking an area.