TABLES_INFO Rowset

OLE DB Programmer's Reference

GUID: DBSCHEMA_TABLES_INFO

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_INFO 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.
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" "EXTERNAL TABLE" "SYSTEM VIEW"
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.
BOOKMARKS	DBTYPE_BOOL	Whether this table supports bookmarks when opening this table with IOpenRowset::OpenRowset or SELECT * FROM <table-name>. VARIANT_TRUE—The table supports bookmarks. VARIANT_FALSE—The table does not support bookmarks.
BOOKMARK_TYPE	DBTYPE_I4	Default bookmark type supported on this table. Contains one of the following values: DBPROPVAL_BMK_NUMERIC—The bookmark type is numeric. DBPROPVAL_BMK_KEY—The bookmark type is key. For more information, see "Bookmark Types" in Chapter 4: Rowsets. This column is not NULL only if the BOOKMARKS column is VARIANT_TRUE.
BOOKMARK_DATATYPE	DBTYPE_UI2	The indicator of the bookmark's native data type. For a list of valid type indicators, see "Type Indicators" in Appendix A. This column is not NULL only if the BOOKMARKS column is VARIANT_TRUE.
BOOKMARK_MAXIMUM_LENGTH	DBTYPE_UI4	Maximum length of the bookmark in bytes. This column is not NULL only if the BOOKMARKS column is VARIANT_TRUE.
BOOKMARK_INFORMATION	DBTYPE_UI4	A bitmask specifying additional information about bookmarks over the rowset. A combination of zero or more of the following: DBPROPVAL_BI_CROSSROWSET—If set, bookmark values are valid across rowsets generated by calling IOpenRowset::OpenRowset on this table. If not set and if supported, bookmark values are valid only within a single rowset over this table.
TABLE_VERSION	DBTYPE_I8	Version number for this table or NULL if the provider does not support returning table version information. This number is assumed to change every time the table is modified through ALTER TABLE, CREATE INDEX, DROP INDEX, or similar statements. The way in which this number is generated is provider specific.
CARDINALITY	DBTYPE_UI8	Cardinality (number of rows) of the table.
DESCRIPTION	DBTYPE_WSTR	Human-readable description of the table.
TABLE_PROPID	DBTYPE_UI4	Property ID of the table. Providers that do not use PROPIDs to identify columns should return NULL in this column.

1998-2001 Microsoft Corporation. All rights reserved.