Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Interactive SQL Online Help Interactive SQL Version 16.0 » Interactive SQL Help » Interactive SQL dialog boxes

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:

NoteYou 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).