MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Microsoft Jet
Version 4.0 of the OLE DB Provider for Microsoft Jet added support for several new schema rowsets that were not available in version 3.5. All previously supported schema rowsets are still supported in version 4.0. Jet schema rowset support is outlined in the following table.
| OLE DB schema name | ADO schema name | Description and GUID (if needed) |
| DBSCHEMA_CHECK_CONSTRAINTS | adSchemaCheckConstraints | The CHECK_CONSTRAINTS rowset identifies the check constraints defined in the catalog that are owned by a given user. |
| DBSCHEMA_COLUMNS | adSchemaColumns | The COLUMNS rowset identifies the columns of tables defined in the catalog that are accessible to a given user. |
| DBSCHEMA_CONSTRAINT_COLUMN_USAGE | adSchemaConstraintColumnUsage | The CONSTRAINT_COLUMN_USAGE rowset identifies the columns used by referential constraints, unique constraints, check constraints, and assertions, defined in the catalog and owned by a given user. |
| DBSCHEMA_FOREIGN_KEYS | adSchemaForeignKeys | The FOREIGN_KEYS rowset identifies the foreign key columns defined in the catalog by a given user. This schema rowset is built upon several SQL-92 schema views as a convenience to the non-SQL programmer. |
| DBSCHEMA_INDEXES | adSchemaIndexes | The INDEXES rowset identifies the indexes defined in the catalog that are owned by a given user. |
| DBSCHEMA_JETOLEDB_ISAMSTATS | NONE | ISAM Performance Statistics
GUID: {8703b612-5d43-11d1-bdbf-00c04fb92675} |
| DBSCHEMA_JETOLEDB_REPLCONFLICTTABLES | NONE | List of Conflict Tables in Replicas
GUID: {e2082df2-54ac-11d1-bbdbb-00c04fb92675} |
| DBSCHEMA_JETOLEDB_REPLPARTIALFILTERLIST | NONE | List of Partial Filters in Replicas
GUID: {e2082df0-54ac-11d1-bdbb-00c04fb92675} |
| DBSCHEMA_JETOLEDB_USERROSTER | NONE | Jet User Roster
GUID: {947bb102-5d43-11d1-bdbf-00c04fb92675} |
| DBSCHEMA_KEY_COLUMN_USAGE | adSchemaKeyColumnUsage | The KEY_COLUMN_USAGE rowset identifies the columns defined in the catalog that are constrained as keys by a given user. |
| DBSCHEMA_PRIMARY_KEYS | adSchemaPrimaryKeys | The PRIMARY_KEYS rowset identifies the primary key columns defined in the catalog by a given user. This schema rowset is built upon an SQL-92 schema view as a convenience to the non-SQL programmer. |
| DBSCHEMA_PROCEDURES | adSchemaProcedures | The PROCEDURES rowset is an OLE DB extension, based on SQL3. It identifies the procedures defined in the catalog that are owned by a given user. |
| DBSCHEMA_PROVIDER_TYPES | adSchemaProviderTypes | The PROVIDER_TYPES rowset identifies the (base) data types supported by the data provider. |
| DBSCHEMA_REFERENTIAL_CONSTRAINTS | adSchemaReferentialConstraints | The REFERENTIAL_CONSTRAINTS rowset identifies the referential constraints defined in the catalog that are owned by a given user. |
| DBSCHEMA_STATISTICS | adSchemaStatistics | The STATISTICS rowset identifies the statistics defined in the catalog that are owned by a given user. |
| DBSCHEMA_TABLE_CONSTRAINTS | adSchemaTableConstraints | The TABLE_CONSTRAINTS rowset identifies the table constraints defined in the catalog that are owned by a given user. |
| DBSCHEMA_TABLES | adSchemaTables | The TABLES rowset identifies the tables defined in the catalog that are accessible to a given user. |
| DBSCHEMA_TABLES_INFO | adSchemaTablesInfo | The TABLES_INFO rowset identifies the tables defined in the catalog that are accessible to a given user. |
| DBSCHEMA_TRUSTEE | adSchemaTrustees | The TRUSTEE schema rowset identifies the trustees defined on the data store. |
| DBSCHEMA_VIEWS | adSchemaViews | The VIEWS rowset identifies the viewed tables defined in the catalog that are accessible to a given user. |