Looking Up Tables, Columns, and Procedures

Use Tools > Lookup Table Name and Tools > Lookup Procedure Name 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.
Task
Enter 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
  1. Choose Tools > Lookup Table Name.
  2. Select the table and click OK to insert the table name into the SQL Statements pane.
Column names
  1. Choose Tools > Lookup Table Name.
  2. Find and select the table containing the column.
  3. Click Show Columns.
  4. Select the column and click OK to insert the column name into the SQL Statements pane.
Procedure names
  1. Choose Tools > Lookup Procedure Name.
  2. Find and select the procedure.
  3. Click OK to insert the procedure name into the SQL Statements pane.