|
Schema Rowset Support in the Advantage OLE DB Provider Advantage OLE DB Provider (for ADO) |
|
|
|
Schema Rowset Support in the Advantage OLE DB Provider Advantage OLE DB Provider (for ADO) |
|
|
The following tables list schema rowsets and the restriction columns supported by the Advantage OLE DB Provider. When specifying the restriction array either from ADO (ADODB.Connection.OpenSchema) or from OLE DB (IDBSchemaRowset::GetRowset), you must specify VT_EMPTY ("Empty" in Visual Basic) as the restriction value. For example, the Advantage OLE DB Provider does not support TABLE_SCHEMA in the TABLES schema rowset, so VT_EMPTY must be specified as the second restriction array value.
Schema Rowset |
Restriction Columns |
DBSCHEMA_TABLES |
The following restrictions are supported. TABLE_CATALOG TABLE_NAME TABLE_TYPE |
DBSCHEMA_COLUMNS |
The following restrictions are supported. TABLE_CATALOG TABLE_NAME COLUMN_NAME |
DBSCHEMA_PROVIDER_TYPES |
The following restrictions are supported. DATA_TYPE BEST_MATCH |
DBSCHEMA_INDEXES |
The following restrictions are supported. TABLE_CATALOG INDEX_NAME TYPE TABLE_NAME |
DBSCHEMA_CATALOGS |
The following restrictions are supported. CATALOG_NAME |
DBSCHEMA_PRIMARY_KEYS |
The following restrictions are supported. TABLE_CATALOG TABLE_NAME |
DBSCHEMA_PROCEDURES |
The following restrictions are supported. PROCEDURE_CATALOG PROCEDURE_NAME PROCEDURE_TYPE |
DBSCHEMA_REFERENTIAL_CONSTRAINTS
|
The following restrictions are supported. CONSTRAINT_CATALOG CONSTRAINT_NAME |
DBSCHEMA_TABLE_CONSTRAINTS |
The following restrictions are supported. CONSTRAINT_CATALOG CONSTRAINT_NAME TABLE_CATALOG TABLE_NAME CONSTRAINT_TYPE |
DBSCHEMA_TABLE_PRIVILEGES |
The following restrictions are supported. TABLE_CATALOG TABLE_NAME GRANTOR GRANTEE |
DBSCHEMA_VIEWS |
The following restrictions are supported. TABLE_CATALOG TABLE_NAME |
The Advantage OLE DB Provider schema rowset support is outlined in the following table.
OLE DB Schema Name |
ADO Schema Name |
Description and GUID (if needed) |
DBSCHEMA_TABLES |
adSchemaTables |
The TABLES rowset identifies the tables defined in the database that are accessible to a given user. |
DBSCHEMA_COLUMNS |
adSchemaColumns |
The COLUMNS rowset identifies the columns of tables defined in the database that are accessible to a given user. |
DBSCHEMA_PROVIDER_TYPES |
adSchemaProviderTypes |
The PROVIDER_TYPES rowset identifies the (base) data types supported by the data provider. |
DBSCHEMA_INDEXES |
adSchemaIndexes |
The INDEXES rowset identifies the indexes defined in the database that are owned by a given user. |
DBSCHEMA_CATALOGS |
adSchemaCatalogs |
The CATALOGS rowset identifies the physical attributes associated with catalogs accessible from the RDBMS. |
DBSCHEMA_PRIMARY_KEYS |
adSchemaPrimaryKeys |
The PRIMARY_KEYS rowset identifies the primary key columns defined in the catalog by a given user. |
DBSCHEMA_PROCEDURES |
adSchemaProcedures |
The PROCEDURES rowset is an OLE DB extension. It identifies the procedures defined in the catalog that are owned by a given user. |
DBSCHEMA_REFERENTIAL_CONSTRAINTS |
adSchemaReferentialConstraints |
The REFERENTIAL_CONSTRAINTS rowset identifies the referential constraints 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_TABLE_PRIVILEGES |
adSchemaTablePrivileges |
The TABLE_PRIVILEGES rowset identifies the privileges on tables defined in the catalog that are available to or granted by a given user. |
DBSCHEMA_VIEWS |
adSchemaViews |
The VIEWS rowset identifies the views defined in the catalog that are accessible to a given user. |