Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere Administration Tools » Interactive SQL

Additional source control actions Next Page

Interactive SQL keyboard shortcuts


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+ASelects 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+FOpens the Find/Replace dialog.
Ctrl+GGoes 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+OOpens 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+VPastes the selected text.
Ctrl+XCuts the selected text.
Ctrl+YRepeats the last operation.
Ctrl+ZUndoes 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.
F3Finds 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.

F11Opens the Connect dialog if Interactive SQL is not connected to a database.
F12Disconnects 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.