Use and to look up the names of tables, columns, or procedures stored in the current
database and insert them at your cursor position.
Prerequisites
Install jConnect for JDBC in order to use these Interactive SQL tools.
TaskEnter the first characters of a table, column, or procedure in the Lookup Table Name
and Lookup Procedure Name dialogs. This list narrows to display only those items that
start with the text you entered.
You can use the standard SQL wildcard character % to mean “match
anything”. Clear the search area to display all items.
| Looking Up |
Description |
|---|
| Table names |
- Choose .
- Select the table and click OK to insert the table name
into the SQL Statements pane.
|
| Column names |
- Choose .
- 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.
|
| Procedure names |
- Choose .
- Find and select the procedure.
- Click OK to insert the procedure name into the SQL
Statements pane.
|