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_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