Interactive SQL provides the following keyboard shortcuts:
| Key(s) | 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+A | Selects all text in the active pane. |
| Ctrl+C |
Copies the selected row(s) 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+F | Opens the Find/Replace dialog. |
| Ctrl+G | Goes to the specified line in the SQL Statements pane. |
| Ctrl+H | Displays the history of your executed SQL. |
| Ctrl+Home | Moves to the top of the current pane. |
| Ctrl+N | Clears the contents of the Interactive SQL window and closes the current file (if any). |
| Ctrl+O | Opens a file. |
| Ctrl+P |
Prints the contents of the SQL Statements pane. You can configure the appearance of the printed text in the Interactive SQL Options dialog. See Print tab. |
| 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+V | Pastes the selected text. |
| Ctrl+X | Cuts the selected text. |
| Ctrl+Y | Repeats the last operation. |
| Ctrl+Z | Undoes the last operation. |
| Esc | Clears the SQL Statements pane. |
| F1 | Opens Help. |
| F2 | Edits the selected value in the result set. You can tab from column to column within the row. |
| F3 | Finds the next occurrence of the specified text. |
| F5 |
Executes all text in the SQL Statements pane. You can also perform this operation by clicking Execute SQL Statement 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 and then press Enter to insert the procedure name into the SQL Statements pane at the cursor position. |
| F9 |
Executes the text that is selected in the SQL Statements pane. If no text is selected, all of the statements are executed. |
| F11 | Opens the Connect dialog if Interactive SQL is not connected to a database. |
| F12 | Disconnects from the database. |
| Page Down | Moves a page down in the current pane. |
| Page Up | Moves a page up in the current pane. |
| Shift+F5 | Displays the plan for the statement in the SQL Statements pane without executing the statement. |
| Shift+F10 |
Displays the context menu for the area that has focus. This keyboard shortcut is an alternative to right-clicking an area. |
The following keyboard shortcuts are available when the SQL Statements pane has the focus:
| Key(s) | Description |
|---|---|
| Ctrl+] | Moves the cursor to the matching brace. Use this shortcut to match parentheses, 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. Use this shortcut to match 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 lower case 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. |