getTables( catalog, schemaPattern, tableNamePattern, types)

Previous Next

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.