When you enter statements in Interactive SQL, you can use text completion look up the names of tables, columns, or procedures stored in the current database and insert them at your cursor position.
Prerequisites
There are no prerequisites for this task.
TaskIn Interactive SQL, click Tools, and then choose one of the following:
| Option | Action |
|---|---|
| Look up table names |
Click Lookup Table Name or press F7. Find and select the table. |
| Look up column names |
Click Lookup Table Name or press F7. Find and select the table containing the column. Click Show Columns. |
| Look up procedure names |
Click Lookup Procedure Name or press F8. Find and select the procedure. |
Enter the first few characters of a table or procedure name to narrow the list of items.
Use the SQL wildcard characters % (percent sign) to match any string of zero or more characters, and '_' (underscore) to match any one character.
Search for a wildcard character within a table name by prefixing it with an escape character. The escape character for the SQL Anywhere ODBC driver and SQL Anywhere JDBC driver is ~ (tilde).
Click OK to insert the name into the SQL Statements pane at the current cursor position.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |