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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL

 

Keyboard shortcuts for Interactive SQL

Interactive SQL provides the following keyboard shortcuts:

Key(s) Description

Alt+F4

Shuts down Interactive SQL.

Alt+Left Arrow

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

Displays the previous SQL statement in the history list.

Alt+Right Arrow

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

Displays the next SQL statement in the history list.
Ctrl+Backspace Deletes the word to the left of the cursor.
Ctrl+Break Interrupts the SQL statement that is being executed. This shortcut is only supported on Windows operating systems.
Ctrl+A

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 rows, columns, and cells from an Interactive SQL result set.

Ctrl+C

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.

Ctrl+Shift+C

Executes a Commit statement.

Note

Executing a COMMIT via the SQL menu or a keyboard shortcut does not modify the contents of the SQL Statements pane; however, the Results tab in the Results pane is cleared.

Ctrl+Del Deletes the word to the right of the cursor.
Ctrl+End Moves the cursor to the bottom of the current pane.
Ctrl+F Opens the Find/Replace window.
Ctrl+Shift+F10

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+G Moves the cursor to the specified line in the SQL Statements pane.

Ctrl+H

On Mac OS X, use Control Command+H.

Displays the history of your executed SQL statement(s).
Ctrl+Home Moves the cursor to the top of the current pane.
Ctrl+L Deletes the current line from the SQL Statements pane and puts the line onto the clipboard.
Ctrl+Shift+L Deletes the current line.
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. Alternatively, click Tools » Options » Editor » Print.
Ctrl+Q

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.

Ctrl+Shift+R

Executes a Rollback statement.

Note

Executing a ROLLBACK via the SQL menu or a keyboard shortcut does not modify the contents of the SQL Statements pane; however, the Results tab in the Results pane is cleared.

Ctrl+S Saves the contents of the SQL Statements pane to the specified file.
Ctrl+U Changes the selection to lowercase characters.
Ctrl+Shift+U Changes the selection to uppercase characters.
Ctrl+V Pastes the selected text.
Ctrl+X Cuts the selected text.
Ctrl+Y Repeats the last operation.
Ctrl+Z Undoes the last operation.
Ctrl+] Moves the cursor to the matching brace. Use this shortcut to match parentheses, braces, brackets, and angle brackets.
Ctrl+Shift+] Extends the selection to the matching brace. Use this shortcut to match parentheses, braces, brackets, and angle brackets.
Ctrl+Minus Sign (-)

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.

Ctrl+Forward Slash (/)

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.

Ctrl+Up Arrow Selects the SQL statement preceding the statement that contains the cursor in the SQL Statements pane.
Ctrl+Down Arrow Selects the SQL statement following the statement that contains the cursor in the SQL Statements pane.
Ctrl+Period (.) Selects the entire SQL statement containing the cursor in the SQL Statements pane. Alternatively, double-click a line to select the entire SQL statement.
Ctrl+Comma (,) Selects the line containing the cursor in the SQL Statements pane.
Ctrl+Shift+Period (.)

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.

Ctrl+Shift+Comma (,)

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

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

Esc

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.

F1 Opens online 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.
Shift+F3 Finds the previous occurrence of the selected text.
F5

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.

Shift+F5 Opens the Plan Viewer for the specified statement in the SQL Statements pane. The specified statement is not executed; to execute the statement in the Plan Viewer, click Get Plan.
F6 Changes the focus from the SQL Statements pane to the Results pane and vice versa. When the Favorites pane is opened, the focus changes between the SQL Statements, Results, and Favorites panes.
F7

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.

F8

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.

F9

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.

Shift+F9

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

Shift+F10

Displays the shortcut menu for the area that has focus.

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

F11 Opens the Connect window if Interactive SQL is not connected to a database.
F12 Disconnects Interactive SQL from the current database.
Home Moves the cursor to the start of the current line or to the first word on the current line.
Shift+Home Extends the selection to the start of the text on the current line.
Page Down Moves a page down in the current pane.
Page Up Moves a page up in the current pane.
 See also