Appendix B: Schema Rowsets

OLE DB Programmer's Reference

Schema information in OLE DB is retrieved using predefined schema rowsets with IDBSchemaRowset::GetRowset. This appendix lists the contents of each schema rowset, including the GUID, the number of restriction columns, the names of the restriction columns, the default sort order, the column names, the data type indicators, and the column descriptions.

Note   Each schema rowset defined in OLE DB is identified by a GUID, which is defined in the OLE DB header file (oledb.h). OLE DB also defines the columns of each rowset and specifies the restriction columns for each rowset. The number of restricted columns in a schema rowset is defined as a constant prefixed with CRESTRICTIONS_ in the OLE DB header file.

As listed in the following table, OLE DB defines two types of schema rowsets: logical information and physical information schema rowsets. Logical information schema rowsets are a superset of information presented by the INFORMATION_SCHEMA views defined in ANSI SQL-92 (with the exception of the COLUMNS and the ROWSETS rowsets, which contain subsets of this information). Physical information schema rowsets represent the physical database structure, such as the file system. This metadata contains OLE DB extensions to the standard, and these extensions are not defined in ANSI SQL-92.

Logical information schema rowsets	Physical information schema rowsets
ASSERTIONS	CATALOGS
CHARACTER_SETS	INDEXES
CHECK_CONSTRAINTS	PROVIDER_TYPES
CHECK_CONSTRAINTS_BY_TABLE	STATISTICS
COLLATIONS	TABLE_STATISTICS
COLUMN_DOMAIN_USAGE
COLUMN_PRIVILEGES
COLUMNS
CONSTRAINT_COLUMN_USAGE
CONSTRAINT_TABLE_USAGE
FOREIGN_KEYS
KEY_COLUMN_USAGE
PRIMARY_KEYS
PROCEDURE_COLUMNS
PROCEDURE_PARAMETERS
PROCEDURES
REFERENTIAL_CONSTRAINTS
SCHEMATA
SQL_LANGUAGES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TABLES
TABLES_INFO
TRANSLATIONS
USAGE_PRIVILEGES
VIEW_COLUMN_USAGE
VIEWS
VIEW_TABLE_USAGE

1998-2001 Microsoft Corporation. All rights reserved.