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.
TABLE_TYPE DBTYPE_WSTR Table type, that is, one of the following (or a provider-specific value):
  • “ALIAS”

  • “TABLE”

  • “SYNONYM”

  • “SYSTEM TABLE”

  • “VIEW”

  • “GLOBAL TEMPORARY”

  • “LOCAL TEMPORARY”
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.