This section details each schema rowset in the logical information schema. These schema rowsets are primarily concerned with the logical database metadata and are a superset of the information presented by the INFORMATION_SCHEMA views defined in ANSI SQL92, with the exception of the COLUMNS and DOMAINS rowsets, which contain subsets of this information. The INFORMATION_SCHEMA schema exists in all ANSI SQL92 catalogs.
Although the ANSI SQL92 views define some columns as NOT NULLABLE, OLE DB does not enforce this restriction. Therefore, consumers should check the metadata for a particular column with IColumnsInfo::GetColumnInfo or IColumnsRowset::GetColumnRowset to determine if it is nullable.
The following rowsets are in the logical information schema. All providers that support IDBSchemaRowset must support the TABLES and COLUMNS schema rowsets. Support for other schema rowsets in the logical information schema is optional.
| ASSERTIONS | PROCEDURE_PARAMETERS |
| CHARACTER_SETS | PROCEDURES |
| CHECK_CONSTRAINTS | REFERENTIAL_CONSTRAINTS |
| COLLATIONS | SCHEMATA |
| COLUMN_DOMAIN_USAGE | SQL_LANGUAGES |
| COLUMN_PRIVILEGES | TABLE_CONSTRAINTS |
| COLUMNS | TABLE_PRIVILEGES |
| CONSTRAINT_COLUMN_USAGE | TABLES |
| CONSTRAINT_TABLE_USAGE | TABLES_INFO |
| FOREIGN_KEYS | TRANSLATIONS |
| KEY_COLUMN_USAGE | USAGE_PRIVILEGES |
| PRIMARY_KEYS | VIEW_COLUMN_USAGE |
| PROCEDURE_COLUMNS | VIEW_TABLE_USAGE |
| VIEWS |