TABLES Rowset

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. This column cannot contain a 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"

This column cannot contain a 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 which 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. Note that 1.x providers do not return this column.

Default Sort Order: TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME