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.
Looking up the names of tables in the database
Choose Tools | Lookup Table Name.
Find and select the table.
Click OK to insert the table name into the SQL Statements pane.
Looking up column names in the database
Choose Tools | Lookup Table Name.
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.
Looking up the names of procedures in the database
Choose Tools | Lookup Procedure Name.
Find and select the procedure.
Click OK to insert the procedure name into the SQL Statements pane.
In the tables and procedures lookup dialogs, you can enter the first few characters of the table or procedure you are looking for. The dialog then narrows the list to include only those items that start with the text you entered.
You can use the standard SQL wildcard % to
mean “match anything.” For example, to list only
those tables ending in order, type %order into
the lookup field. To list all items containing the word java,
type %java%.
Clearing the search criteria from the look up field resets the filtering
to display all the items.
