TABLES Rowset

OLE DB Programmer's Reference

GUID: DBSCHEMA_TABLES

Number of restriction columns: 4

Restriction columns: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE

Default sort order: TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME

Description: The TABLES rowset identifies the tables (including views) defined in the catalog that are accessible to a given user.

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.

1998-2001 Microsoft Corporation. All rights reserved.