Lookup Table Name dialog

The Lookup Table Name dialog allows you to look up the names of tables and columns stored in the database that you are currently connected to. Once you find the table or column name you are looking for, you can insert it into the SQL Statements pane at your current cursor position.

The Lookup Table Name dialog has the following components:

Type the first few characters of the table you're looking for Type the first few characters of the table name in the text box to restrict the list of tables to only those that start with the text you enter.

Click the table you want, then click OK or Show Columns Select the desired table from the list and then click OK to insert the table name into the SQL Statements pane.

You can use the following options to restrict the tables that appear in the list. If you know what type of table you are looking for, select only that type to restrict the list. You can select any or all of the table types listed below, and you can also choose to show the names of the table owner in the list.

Show tables All permanent, non-system tables owned by any owner. Temporary tables do not appear in the list of tables.
Show system tables All system tables.
Show views All views.
Show owner names Select this option to include table owners in the list.

More Select this option to show the SQL text of the stored procedure. Click Less to hide the SQL text.

Show Columns Once you select a table from the list, click Show Columns to see a list of all of the columns in the selected table. In the Select Column dialog, click OK to enter the selected column name into the SQL Statements pane at your current cursor position.

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 depends on the JDBC driver that you are using. If you are connected via jConnect, the escape character is '\' (backslash) while the escape character for the iAnywhere JDBC driver is '~' (tilde) character ‘\’ (backslash).