|
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
|
Note: Some databases may not return information for all tables.
Syntax
getTables(string catalog, string schemaPattern, string tableNamePattern, string types)
Parameters
catalog
A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
schemaPattern
A schema name pattern; "" retrieves those without a schema
tableNamePattern
A table name pattern
types
A list of table types to include; null returns all types
|
