Restricting the List of Database Tables
You can restrict the list of database tables that the server displays by specifying one or more of the following:
Catalog. You specify the name of the catalog whose tables you want to use.
![*](chapterTOC_bullet.png)
If you are not working with a distributed database, do not restrict by catalog.
![*](chapterTOC_bullet.png)
If you are working with a distributed database, you can specify the name of the database with which you want to work. If you are using DB2, use this field to specify the name of a DB2 location.
Schema pattern. You specify the schemas whose tables you want to work with (if you are using DB2, use this field to specify an AuthID).
![*](chapterTOC_bullet.png)
If you want tables for all schemas in the selected database, do not restrict by schema pattern.
![*](chapterTOC_bullet.png)
If you want to restrict your search to tables by selected schemas, specify the schema name. You can specify a pattern-matching string if your JDBC supports it. Most drivers support the pattern-matching characters described for Table name pattern below; however, check your driver’s documentation for information about its pattern-matching capabilities.
Table name pattern. You specify the names of the tables with which you want to work. Specify a table name or a pattern-matching string that specifies the names of the tables. Most drivers support the following pattern-matching characters; however, check your driver’s documentation for information about its pattern-matching capabilities.
Use | To match | For example |
% | Any string of characters | HR% matches: HR30all, HR15mgmt, HR01payroll, and so forth. |
_ | A single character | HR3_mgmt matches: HR30mgmt, HR31mgmt, HR3Amgmt, and so forth. |
Table type. The type of the tables for which you want information. You can choose from the following common JDBC table types: Table, View, System Table, Global Temporary, Local Temporary, Alias, and Synonym.