Specifies the type of schema Recordset that the OpenSchema method retrieves.
| Constant |
Value |
Description |
adSchemaAsserts |
0 |
Returns the assertions defined in the catalog that are owned by a
given user. |
adSchemaCatalogs |
1 |
Returns the physical attributes associated with catalogs accessible
from the DBMS. |
adSchemaCharacterSets |
2 |
Returns the character sets defined in the catalog that are accessible
to a given user. |
adSchemaCheckConstraints |
5 |
Returns the check constraints defined in the catalog that are owned
by a given user. |
adSchemaCollations |
3 |
Returns the character collations defined in the catalog that are accessible
to a given user. |
adSchemaColumnPrivileges |
13 |
Returns the privileges on columns of tables defined in the catalog
that are available to, or granted by, a given user. |
adSchemaColumns |
4 |
Returns the columns of tables (including views) defined in the catalog
that are accessible to a given user. |
adSchemaColumnsDomainUsage |
11 |
Returns the columns defined in the catalog that are dependent on a
domain defined in the catalog and owned by a given user. |
adSchemaConstraintColumnUsage |
6 |
Returns the columns used by referential constraints, unique constraints,
check constraints, and assertions, defined in the catalog and owned
by a given user. |
adSchemaConstraintTableUsage |
7 |
Returns the tables that are used by referential constraints, unique
constraints, check constraints, and assertions defined in the catalog
and owned by a given user. |
adSchemaCubes |
32 |
Returns information about the available cubes in a schema (or the
catalog, if the provider does not support schemas). |
adSchemaDBInfoKeywords |
30 |
Returns a list of provider-specific keywords. |
adSchemaDBInfoLiterals |
31 |
Returns a list of provider-specific literals used in text commands. |
adSchemaDimensions |
33 |
Returns information about the dimensions in a given cube. It has one
row for each dimension. |
adSchemaForeignKeys |
27 |
Returns the foreign key columns defined in the catalog by a given
user. |
adSchemaHierarchies |
34 |
Returns information about the hierarchies available in a dimension. |
adSchemaIndexes |
12 |
Returns the indexes defined in the catalog that are owned by a given
user. |
adSchemaKeyColumnUsage |
8 |
Returns the columns defined in the catalog that are constrained as
keys by a given user. |
adSchemaLevels |
35 |
Returns information about the levels available in a dimension. |
adSchemaMeasures |
36 |
Returns information about the available measures. |
adSchemaMembers |
38 |
Returns information about the available members. |
adSchemaPrimaryKeys |
28 |
Returns the primary key columns defined in the catalog by a given
user. |
adSchemaProcedureColumns |
29 |
Returns information about the columns of rowsets returned by procedures. |
adSchemaProcedureParameters |
26 |
Returns information about the parameters and return codes of procedures. |
adSchemaProcedures |
16 |
Returns the procedures defined in the catalog that are owned by a
given user. |
adSchemaProperties |
37 |
Returns information about the available properties for each level
of the dimension. |
adSchemaProviderTypes |
22 |
Returns the (base) data types supported by the data provider. |
adSchemaReferentialConstraints |
9 |
Returns the referential constraints defined in the catalog that are
owned by a given user. |
adSchemaSchemata |
17 |
Returns the schemas (database objects) that are owned by a given user. |
adSchemaSQLLanguages |
18 |
Returns the conformance levels, options, and dialects supported by
the SQL-implementation processing data defined in the catalog. |
adSchemaStatistics |
19 |
Returns the statistics defined in the catalog that are owned by a
given user. |
adSchemaTableConstraints |
10 |
Returns the table constraints defined in the catalog that are owned
by a given user. |
adSchemaTablePrivileges |
14 |
Returns the privileges on tables defined in the catalog that are available
to, or granted by, a given user. |
adSchemaTables |
20 |
Returns the tables (including views) defined in the catalog that are
accessible to a given user. |
adSchemaTranslations |
21 |
Returns the character translations defined in the catalog that are
accessible to a given user. |
adSchemaTrustees |
39 |
Reserved for future use. |
adSchemaUsagePrivileges |
15 |
Returns the USAGE privileges on objects defined in the catalog that
are available to, or granted by, a given user. |
adSchemaViewColumnUsage |
24 |
Returns the columns on which viewed tables, defined in the catalog
and owned by a given user, are dependent. |
adSchemaViews |
23 |
Returns the views defined in the catalog that are accessible to a
given user. |
adSchemaViewTableUsage |
25 |
Returns the tables on which viewed tables, defined in the catalog
and owned by a given user, are dependent. |
