Interactive SQL provides the keyboard shortcuts listed in Table 2-2.
Function key |
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+Break |
Interrupts the SQL statement that is being executed. |
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. |
Esc |
Clears the SQL Statements pane. |
F1 |
Opens Help. |
F2 |
Edits the selected value 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. |
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. |
The keyboard shortcuts in Table 2-3 are available when the SQL Statements pane has the focus:
Function key |
Description |
---|---|
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+L |
Deletes the current line. |
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. |