Interactive SQL Keyboard Shortcuts

Tab

Accepts the selection and closes the text completion window.

Alt+F4

Exits Interactive SQL.

Ctrl+A

Shows a content-free list of matches.

Ctrl+C

Copies the selected rows and column headings to the clipboard in the Results pane.

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

Ctrl+End

Moves to the bottom of the current pane.

Ctrl+H

Displays the history of your executed SQL statements.

Ctrl+Home

Moves to the top of the current pane.

Ctrl+N

Clears the contents of the Interactive SQL window.

Ctrl+P

Prints the contents of the SQL Statements pane.

Ctrl+Q

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

Ctrl+S

Saves the contents of the SQL Statements pane.

Ctrl+Plus Sign (+)

Adds the item with its parameter list to the SQL Statements pane.

Ctrl+Asterisk

Adds the item with its parameter and type list to the SQL Statements pane.

Ctrl+Double quote (")

Adds the item enclosed in quotation marks to the SQL Statements pane.

F2

Edits the selected value in the result set.

F5

Executes all text in the SQL Statements pane.

F7

Displays the Lookup Table Name dialog.

F8

Displays the Lookup Procedure Name dialog.

F9

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

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

Pgdn

Moves a page down in the current pane.

Pgup

Moves a page up in the current pane.

Ctrl+]

Moves the cursor to the matching parenthesis, braces, brackets, and angle brackets.

Ctrl+Backspace

Deletes the word to the left of the cursor.

Ctrl+Del

Deletes the word to the right of the cursor.

Ctrl+G

Opens the Go To dialog where you can specify the line you want to go to.

Ctrl+L

Deletes the current line from the SQL Statements pane and puts the line onto the clipboard.

Ctrl+Shift+]

Extends the selection to the matching brace. Brace matching matches parentheses, braces, brackets, and angle brackets.

Ctrl+Shift+C

Executes a COMMIT statement.

Ctrl+Shift+L

Deletes the current line.

Ctrl+Shift+R

Executes a ROLLBACK statement.

Ctrl+Shift+U

Changes the selection to uppercase characters.

Ctrl+U

Changes the selection to lowercase characters.

F3

Finds the next occurrence of the selected text.

Home

Moves the cursor to the start of the current line or to the first word on the current line.

Shift+F3

Finds the previous occurrence of the selected text.

Shift+Home

Extends the selection to the start of the text on the current line.