Listing All Tables or Views In a Database - SQL Assistant

Listing All Tables or Views In a Database

To list the tables or views of any database

1 Do one of the following:

Select Tools > List Tables.

On the toolbar click .

2 In the Database Name field, type the name of the database (or owner, if using Oracle) containing the tables.

Enter the following wildcard characters in this field:

Note: 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 "_%".

Note: This field does not apply to Microsoft Access databases.

3 At least one of the following must be selected:

Show Tables lists the tables in the selected database.

Show Views lists the views in the selected database.

The resulting list of tables, views and/or system tables appears in an Answerset window. This window does not automatically close when new queries are submitted.