Do one of the following:
- Click .
- Select .
In Database Name, type the name of the database (or owner, if using Oracle) containing the tables.
Enter the following wildcard characters in this field:Wildcard characters only function when using an ODBC connection.
- "_" Matches any single character
- "%" Matches zero or more characters
If the name is specified as a single percent sign ("%") this has special meaning to some ODBC drivers. It requests a list of all databases on the system, rather than all Tables within all Databases. To display all tables in all databases, it is safer to specify either "%%" or "_%".This field does not apply to Microsoft Access databases.
Select one or both options:
- Show Tables – lists the tables in the selected database.
- Show Views – lists the views in the selected database.
The resulting list of tables, views, or system tables appears in an Answerset window. This window does not automatically close when new queries are submitted.