| Constant | Value | Description | Constraint Columns |
|---|---|---|---|
| adSchemaAsserts | 0 | Returns the assertions defined in the catalog that are owned by a given user. | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME |
| adSchemaCatalogs | 1 | Returns the physical attributes associated with catalogs accessible from the DBMS. | CATALOG_NAME |
| adSchemaCharacterSets | 2 | Returns the character sets defined in the catalog that are accessible to a given user. | CHARACTER_SET_CATALOG CHARACTER_SET_SCHEMA CHARACTER_SET_NAME |
| adSchemaCheckConstraints | 5 | Returns the check constraints defined in the catalog that are owned by a given user. | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME |
| adSchemaCollations | 3 | Returns the character collations defined in the catalog that are accessible to a given user. | COLLATION_CATALOG COLLATION_SCHEMA COLLATION_NAME |
| adSchemaColumnPrivileges | 13 | Returns the privileges on columns of tables defined in the catalog that are available to, or granted by, a given user. | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME GRANTOR GRANTEE |
| adSchemaColumns | 4 | Returns the columns of tables (including views) defined in the catalog that are accessible to a given user. | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| 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. | DOMAIN_CATALOG DOMAIN_SCHEMA DOMAIN_NAME COLUMN_NAME |
| 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. | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| 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. | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME |
| adSchemaCubes | 32 | Returns information about the available cubes in a schema (or the catalog, if the provider does not support schemas). | CATALOG_NAME SCHEMA_NAME CUBE_NAME |
| adSchemaDBInfoKeywords | 30 | Returns a list of provider-specific keywords. | <None> |
| adSchemaDBInfoLiterals | 31 | Returns a list of provider-specific literals used in text commands. | <None> |
| adSchemaDimensions | 33 | Returns information about the dimensions in a given cube. It has one row for each dimension. | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_NAME DIMENSION_UNIQUE_NAME |
| adSchemaForeignKeys | 27 | Returns the foreign key columns defined in the catalog by a given user. | PK_TABLE_CATALOG PK_TABLE_SCHEMA PK_TABLE_NAME FK_TABLE_CATALOG FK_TABLE_SCHEMA FK_TABLE_NAME |
| adSchemaHierarchies | 34 | Returns information about the hierarchies available in a dimension. | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_NAME HIERARCHY_UNIQUE_NAME |
| adSchemaIndexes | 12 | Returns the indexes defined in the catalog that are owned by a given user. | TABLE_CATALOG TABLE_SCHEMA INDEX_NAME TYPE TABLE_NAME |
| adSchemaKeyColumnUsage | 8 | Returns the columns defined in the catalog that are constrained as keys by a given user. | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME |
| adSchemaLevels | 35 | Returns information about the levels available in a dimension. | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_NAME LEVEL_UNIQUE_NAME |
| adSchemaMeasures | 36 | Returns information about the available measures. | CATALOG_NAME SCHEMA_NAME CUBE_NAME MEASURE_NAME MEASURE_UNIQUE_NAME |
| adSchemaMembers | 38 | Returns information about the available members. | 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 | 28 | Returns the primary key columns defined in the catalog by a given user. | PK_TABLE_CATALOG PK_TABLE_SCHEMA PK_TABLE_NAME |
| adSchemaProcedureColumns | 29 | Returns information about the columns of rowsets returned by procedures. | PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME COLUMN_NAME |
| adSchemaProcedureParameters | 26 | Returns information about the parameters and return codes of procedures. | PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME PARAMETER_NAME |
| adSchemaProcedures | 16 | Returns the procedures defined in the catalog that are owned by a given user. | PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME PROCEDURE_TYPE |
| adSchemaProperties | 37 | Returns information about the available properties for each level of the dimension. | CATALOG_NAME SCHEMA_NAME CUBE_NAME DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_UNIQUE_NAME MEMBER_UNIQUE_NAME PROPERTY_TYPE PROPERTY_NAME |
| adSchemaProviderSpecific | -1 | Used if the provider defines its own nonstandard schema queries. | <Provider specific> |
| adSchemaProviderTypes | 22 | Returns the (base) data types supported by the data provider. | DATA_TYPE BEST_MATCH |
| AdSchemaReferentialConstraints | 9 | Returns the referential constraints defined in the catalog that are owned by a given user. | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME |
| adSchemaSchemata | 17 | Returns the schemas (database objects) that are owned by a given user. | CATALOG_NAME SCHEMA_NAME SCHEMA_OWNER |
| adSchemaSQLLanguages | 18 | Returns the conformance levels, options, and dialects supported by the SQL-implementation processing data defined in the catalog. | <None> |
| adSchemaStatistics | 19 | Returns the statistics defined in the catalog that are owned by a given user. | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME |
| adSchemaTableConstraints | 10 | Returns the table constraints defined in the catalog that are owned by a given user. | CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE |
| adSchemaTablePrivileges | 14 | Returns the privileges on tables defined in the catalog that are available to, or granted by, a given user. | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME GRANTOR GRANTEE |
| adSchemaTables | 20 | Returns the tables (including views) defined in the catalog that are accessible to a given user. | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE |
| adSchemaTranslations | 21 | Returns the character translations defined in the catalog that are accessible to a given user. | TRANSLATION_CATALOG TRANSLATION_SCHEMA TRANSLATION_NAME |
| 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. | OBJECT_CATALOG OBJECT_SCHEMA OBJECT_NAME OBJECT_TYPE GRANTOR GRANTEE |
| adSchemaViewColumnUsage | 24 | Returns the columns on which viewed tables, defined in the catalog and owned by a given user, are dependent. | VIEW_CATALOG VIEW_SCHEMA VIEW_NAME |
| adSchemaViews | 23 | Returns the views defined in the catalog that are accessible to a given user. | TABLE_CATALOG TABLE_SCHEMA TABLE_NAME |
| adSchemaViewTableUsage | 25 | Returns the tables on which viewed tables, defined in the catalog and owned by a given user, are dependent. | VIEW_CATALOG VIEW_SCHEMA VIEW_NAME |
OpenSchema SchemaEnum
最新推荐文章于 2026-03-16 22:10:50 发布
扫一扫
1600
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
