While you are entering commands in Interactive SQL, you can look up the names of tables, columns, or procedures stored in the current database and insert them at your cursor position.
To look up the names of tables in the databaseFrom the Tools menu, choose Lookup Table Name or press F7.
Find and select the table.
Click OK to insert the table name into the SQL Statements pane at the current cursor position.
To look up column names in the databaseFrom the Tools menu, choose Lookup Table Name or press F7.
Find and select the table containing the column.
Click Show Columns.
Select the column and click OK to insert the column name into the SQL Statements pane at the current cursor position.
To look up the names of procedures in the databaseFrom the Tools menu, choose Lookup Procedure Name or press F8.
Find and select the procedure.
Click OK to insert the procedure name into the SQL Statements pane at the current cursor position.
In the Lookup Table Name and Lookup Procedure Name windows, you can enter the first few characters of the table or procedure you are looking for. The list is narrowed to include only those items that start with the text you entered.
You can use the SQL wildcard characters '%' (percent sign) and '_' (underscore) to help narrow your search. '%' matches any string of zero or more characters, while '_' matches any one character.
For example, to list all the tables that contain the word profile, type %profile%.
If you want to search for a percent sign or underscore within a table name, you must prefix the percent sign or underscore with an escape character. The escape character for the SQL Anywhere ODBC driver and SQL Anywhere JDBC driver is '~' (tilde).
Interactive SQL supports text completion for database object names when you type in the SQL Statements pane, which can be used as an alternative to looking up table and procedure names. See Using text completion.
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |