MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets
The TABLES rowset identifies the tables (including views) 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. This column cannot contain NULL. |
TABLE_TYPE | DBTYPE_WSTR | Table type. One of the following or a provider-specific value:
"ALIAS" This column cannot contain NULL. |
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. Null if there is no description associated with the column. |
TABLE_PROPID | DBTYPE_UI4 | Property ID of the table. Providers that do not use PROPIDs to identify columns should return NULL in this column. |
DATE_CREATED | DBTYPE_DATE | Date when the table was created or NULL if the provider does not have this information. Note that 1.x providers do not return this column. |
DATE_MODIFIED | DBTYPE_DATE | Date when the table definition was last modified or NULL if the provider does not have this information.
1.x providers do not return this column. |
Default Sort Order: TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME