J.3. Connection.OpenSchema Method Options
The following tables list the values you can specify for the Command.OpenSchema method's schema and restrictions argument.
J.3.1. Schema Argument Values
The Schema argument specifies the type of information to return and its values are defined in the following table.
We have included only those values that have meaning in Access. The four remaining values, adSchemaActions, adSchemaCommands, adSchemaFunctions, and adSchemaSets relate specifically to the Microsoft OLE DB Provider for OLAP Services library. For more information about these values, refer to the Microsoft KnowledgeBase.
| Option | Value | Description |
|---|---|---|
| AdSchemaAsserts | 0 | Returns the constraints defined in the catalog. Unsupported by the Jet provider. |
| AdSchemaCatalogs | 1 | Returns the catalogs that are accessible from the database. Unsupported by the Jet provider. |
| AdSchemaCharacterSets | 2 | Returns the character sets defined in the catalog. Unsupported by the Jet provider. |
| AdSchemaCheckConstraints | 4 | Returns the check constraints (validation rules) defined in the catalog. |
| AdSchemaCollations | 3 | Returns the sort orders defined in the catalog. Unsupported by the Jet provider. |
| AdSchemaColumnPrivileges | 13 | Returns the privileges on columns that are available to, or granted by, a given user. Unsupported by the Jet provider. |
| AdSchemaColumns | 4 | Returns the columns of tables and views that are accessible to a given user. |
| adSchemaColumnsDomainUsage | 11 | Returns the columns that are dependent on a domain that is owned by a given user. Unsupported by the Jet provider. |
| adSchemaConstraintColumnUsage | 6 | Returns the columns used by referential constraints, unique constraints, check constraints, and assertions. |
| adSchemaConstraintTableUsage | 7 | Returns the tables that are used by referential constraints, unique constraints, check constraints, and assertions for a given user. Unsupported by the Jet provider. |
| adSchemaCubes | 32 | Returns information about the available cubes (multidimensional data) in a schema (or the catalog, if the provider does not support schemas). Unsupported by the Jet provider. |
| adSchemaDBInfoKeywords | 30 | Returns a list of provider-specific keywords |
| adSchemaDBInfoLiterals | 31 | Returns a list of provider-specific literals (quotes and escape characters) used in text commands. |
| adSchemaDimensions | 33 | Returns information about the dimensions in a cube; one row per dimension. Unsupported by the Jet provider. |
| adSchemaForeignKeys | 27 | Returns the foreign key columns defined in the catalog. |
| adSchemaHierarchies | 34 | Returns information about the hierarchies available in a cube dimension. Unsupported by the Jet provider. |
| adSchemaIndexes | 12 | Returns the indexes defined in the catalog. |
| adSchemaKeyColumnUsage | 8 | Returns the columns that are defined in the catalog as keys. |
| adSchemaLevels | 35 | Returns information about the levels available in a cube dimension. Unsupported by the Jet provider. |
| adSchemaMeasures | 36 | Returns information about the available cube measures. Unsupported by the Jet provider. |
| adSchemaMembers | 38 | Returns information about the available cube members. Unsupported by the Jet provider. |
| adSchemaPrimaryKeys | 28 | Returns the primary key columns defined in the catalog. |
| adSchemaProcedureColumns | 29 | Returns information about the columns in stored procedures. Unsupported by the Jet provider. |
| adSchemaProcedureParameters | 26 | Returns information about the parameters and return codes of stored procedures. Unsupported by the Jet provider. |
| adSchemaProcedures | 16 | Returns the procedures defined in the catalog. Unsupported by the Jet provider. |
| adSchemaProperties | 37 | Returns information about the available properties for each level of the cube dimension. Unsupported by the Jet provider. |
| adSchemaProviderSpecific | −1 | Returns schema information for a provider that defines its own nonstandard schema queries. |
| adSchemaProviderTypes | 22 | Returns the base datatypes supported by the provider. |
| adSchemaReferentialConstraints | 9 | Returns the referential constraints (relationships) defined in the catalog. |
| adSchemaSchemata | 17 | Returns the schemas (database objects) that are owned by a given user. Unsupported by the Jet provider. |
| adSchemaSQLLanguages | 18 | Returns the levels of ANSI SQLconformance, options and dialects supported in the catalog. Unsupported by the Jet provider. |
| adSchemaStatistics | 19 | Returns the catalog statistics. |
| adSchemaTableConstraints | 10 | Returns the table constraints (validation rules) defined in the catalog. |
| adSchemaTablePrivileges | 14 | Returns the privileges on tables that are available to, or granted by, a given user. Unsupported by the Jet provider. |
| adSchemaTables | 20 | Returns the tables and views defined in the catalog. |
| adSchemaTranslations | 21 | Returns the character translations defined in the catalog. Unsupported by the Jet provider. |
| adSchemaTrustees | 39 | Returns the users and groups defined in the catalog. |
| adSchemaUsagePrivileges | 15 | Returns the USAGE privileges on objects that are available to, or granted by, a given user. Unsupported by the Jet provider. |
| adSchemaViewColumnUsage | 24 | Returns the columns included in views. Unsupported by the Jet provider. |
| adSchemaViews | 23 | Returns the views defined in the catalog. |
| adSchemaViewTableUsage | 25 | Returns the tables included in views. Unsupported by the Jet provider. |
J.3.2. Restrictions Argument Values
The optional Restrictions parameter allows you to filter the output. For example, you can filter the recordset to return only a single table or view. The available values are listed in the following table.
| Option | Constraint columns |
|---|---|
| AdSchemaAsserts | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA |
| CONSTRAINT_NAME | |
| AdSchemaCatalogs | CATALOG_NAME |
| AdSchemaCharacterSets | CHARACTER_SET_CATALOG |
| CHARACTER_SET_SCHEMA CHARACTER_SET_NAME | |
| AdSchemaCheckConstraints | CONSTRAINT_CATALOG |
| CONSTRAINT_SCHEMA CONSTRAINT_NAME | |
| AdSchemaCollations | COLLATION_CATALOG |
| COLLATION_SCHEMA COLLATION_NAME | |
| AdSchemaColumnPrivileges | TABLE_CATALOG |
| TABLE_SCHEMA
TABLE_NAME COLUMN_NAME GRANTOR GRANTEE | |
| AdSchemaColumns | TABLE_CATALOG
TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| AdSchemaColumnsDomainUsage | DOMAIN_CATALOG
DOMAIN_SCHEMA DOMAIN_NAME COLUMN_NAME |
| AdSchemaConstraintColumnUsage | TABLE_CATALOG
TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| AdSchemaConstraintTableUsage | TABLE_CATALOG
TABLE_SCHEMA TABLE_NAME |
| AdSchemaCubes | CATALOG_NAME
SCHEMA_NAME CUBE_NAME |
| AdSchemaDBInfoKeywords | <None> |
| AdSchemaDBInfoLiterals | <None> |
| AdSchemaDimensions | CATALOG_NAME
SCHEMA_NAME CUBE_NAME DIMENSION_NAME DIMENSION_UNIQUE_NAME |
| AdSchemaForeignKeys | PK_TABLE_CATALOG
PK_TABLE_SCHEMA PK_TABLE_NAME FK_TABLE_CATALOG FK_TABLE_SCHEMA FK_TABLE_NAME |
| AdSchemaHierarchies | CATALOG_NAME
SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_NAME HIERARCHY_UNIQUE_NAME |
| AdSchemaIndexes | TABLE_CATALOG
TABLE_SCHEMA INDEX_NAME TYPE TABLE_NAME |
| AdSchemaKeyColumnUsage | CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| AdSchemaLevels | CATALOG_NAME
SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_NAME LEVEL_UNIQUE_NAME |
| AdSchemaMeasures | CATALOG_NAME
SCHEMA_NAME CUBE_NAME MEASURE_NAME MEASURE_UNIQUE_NAME |
| AdSchemaMembers | CATALOG_NAME
SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_UNIQUE_NAME LEVEL_NUMBER MEMBER_NAME MEMBER_UNIQUE_NAME MEMBER_CAPTION MEMBER_TYPE Tree operator (For more information, see the OLE DB for OLAP documentation.) |
| AdSchemaPrimaryKeys | PK_TABLE_CATALOG
PK_TABLE_SCHEMA PK_TABLE_NAME |
| AdSchemaProcedureColumns | PROCEDURE_CATALOG
PROCEDURE_SCHEMA PROCEDURE_NAME COLUMN_NAME |
| AdSchemaProcedureParameters | PROCEDURE_CATALOG
PROCEDURE_SCHEMA PROCEDURE_NAME PARAMETER_NAME |
| AdSchemaProcedures | PROCEDURE_CATALOG
PROCEDURE_SCHEMA PROCEDURE_NAME PROCEDURE_TYPE |
| AdSchemaProperties | CATALOG_NAME
SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_UNIQUE_NAME MEMBER_UNIQUE_NAME PROPERTY_TYPE PROPERTY_NAME |
| AdSchemaProviderSpecific | <Provider specific> |
| AdSchemaProviderTypes | DATA_TYPE BEST_MATCH |
| AdSchemaReferentialConstraints | CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA CONSTRAINT_NAME |
| AdSchemaSchemata | CATALOG_NAME
SCHEMA_NAME SCHEMA_OWNER |
| AdSchemaSQLLanguages | <None> |
| AdSchemaStatistics | TABLE_CATALOG
TABLE_SCHEMA TABLE_NAME |
| AdSchemaTableConstraints | CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE |
| AdSchemaTablePrivileges | TABLE_CATALOG
TABLE_SCHEMA TABLE_NAME GRANTOR GRANTEE |
| AdSchemaTables | TABLE_CATALOG
TABLE_SCHEMA TABLE_NAME TABLE_TYPE |
| AdSchemaTranslations | TRANSLATION_CATALOG
TRANSLATION_SCHEMA TRANSLATION_NAME |
| AdSchemaTrustees | <None> |
| AdSchemaUsagePrivileges | OBJECT_CATALOG
OBJECT_SCHEMA OBJECT_NAME OBJECT_TYPE GRANTOR GRANTEE |
| AdSchemaViewColumnUsage | VIEW_CATALOG
VIEW_SCHEMA VIEW_NAME |
| AdSchemaViews | TABLE_CATALOG
TABLE_SCHEMA TABLE_NAME |
| AdSchemaViewTableUsage | VIEW_CATALOG
VIEW_SCHEMA VIEW_NAME |