getTables( catalog, schemaPattern, tableNamePattern, types)

Gets a description of tables available in a catalog. Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME. Each table description has the following columns:

TABLE_CAT	String	table catalog (may be null)
TABLE_SCHEM	String	table schema (may be null)
TABLE_NAME	String	table name
TABLE_TYPE	String	table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
REMARKS	String	explanatory comment on the table

Syntax

getTables( string catalog, string schemaPattern, string tableNamePattern, ? types )

Parameters

catalog	The catalog that the procedure is in
schemaPattern	A schema name pattern
tableNamePattern	A table name pattern
types	A list of table types to include

If catalog is "" (the empty string), only procedures without a catalog are returned.

If catalog is the null value, catalog names are not part of the selection criteria.

If schemaPattern is "" (the empty string), only procedures without a schema are returned.

If types is the null value, types are not part of the selection criteria.

Notes

Some databases may not return information for all tables.