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.
You must have jConnect for JDBC installed to use the functionality described
in this section.
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 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 procedure names 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.
