MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets


 

TABLES Rowset

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"
"TABLE"
"SYNONYM"
"SYSTEM TABLE"
"VIEW"
"GLOBAL TEMPORARY"
"LOCAL TEMPORARY"
"SYSTEM VIEW"

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