MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets
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 SQL-92, with the exception of the COLUMNS and DOMAINS rowsets, which contain subsets of this information. The INFORMATION_SCHEMA schema exists in all ANSI SQL-92 catalogs.
Although the ANSI SQL-92 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 whether 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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|