The TABLES rowset identifies the tables defined in the catalog that are accessible to a given user.
The TABLES rowset contains the following columns:
Column name | Type indicator | Description |
TABLE_CATALOG | DBTYPE_WSTR | Catalog name. NULL if the provider does not support catalogs. |
TABLE_SCHEMA | DBTYPE_WSTR | Unqualified schema name. NULL if the provider does not support schemas. |
TABLE_NAME | DBTYPE_WSTR | Table name. |
TABLE_TYPE | DBTYPE_WSTR | Table type, that is, one of the following (or a provider-specific value):
|
TABLE_GUID | DBTYPE_GUID | GUID that uniquely identifies the table. Providers that do not use GUIDs to identify tables should return NULL in this column. |
DESCRIPTION | DBTYPE_WSTR | Human-readable description of the table. |
Default Sort Order: TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME.