TABLES_INFO Rowset

The TABLES_INFO rowset identifies the tables defined in the catalog that are accessible to a given user.

The TABLES_INFO 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. One of the following or a provider-specific value.

“ALIAS”
“TABLE”
“SYNONYM”
“SYSTEM TABLE”
“VIEW”
“GLOBAL TEMPORARY”
“LOCAL TEMPORARY”
“EXTERNAL TABLE”

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.

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 OpenRowset on this table.  If not set, bookmark values, if supported, 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 which do not use PROPIDs to identify columns should return NULL in this column.

Default Sort Order: TABLE_TYPE, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME