Share via


Appendix B: Schema Rowsets

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

This topic is a part of: