The following keyboard shortcuts are available when the text completion list is open.
| Key | Description |
|---|---|
| Ctrl+C | Shows only columns in the text completion list. |
| Ctrl+F | Shows only SQL functions in the text completion list. |
| Ctrl+P | Shows only stored procedures and functions in the text completion list. |
| Ctrl+S | Changes the contents of the list to show or hide system objects. |
| Ctrl+Shift+Space | Opens the text completion window. You can also use Ctrl+Space to open the text completion window. |
| Ctrl+T | Shows only tables in the text completion list. |
| Ctrl+V | Shows only views in the text completion list. |
| Escape | Closes the text completion window without adding any text. |
| Tab | Toggles between a list of all database object names and a list of names that match what has been typed so far. |
| * |
For tables, inserts a comma separated list of columns, including data types. For stored procedures, inserts the procedure name, followed by a comma-separated list of parameter names and their data types. |
| + |
For tables, inserts a comma-separated list of columns. For stored procedures, inserts the procedure name, followed by a comma-separated list of parameter names. |
| " | Completes the name, enclosing it in quotation marks, regardless of the setting of the quoted_identifier option. See quoted_identifier option [compatibility]. |
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |