Openschema Schemaenum

ConstantValueDescriptionConstraint ColumnsadSchemaAsserts0Returns the assertions defined in the catalog that are owned by a given user. (ASSERTIONS Rowset) CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMEadSchemaCatalogs1Returns the physical attributes associated with catalogs accessible from the DBMS. (CATALOGS Rowset) CATALOG_NAMEadSchemaCharacterSets2Returns the character sets defined in the catalog that are accessible to a given user. (CHARACTER_SETS Rowset) CHARACTER_SET_CATALOGCHARACTER_SET_SCHEMACHARACTER_SET_NAMEadSchemaCheckConstraints5Returns the check constraints defined in the catalog that are owned by a given user. (CHECK_CONSTRAINTS Rowset) CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMEadSchemaCollations3Returns the character collations defined in the catalog that are accessible to a given user. (COLLATIONS Rowset) COLLATION_CATALOGCOLLATION_SCHEMACOLLATION_NAMEadSchemaColumnPrivileges13Returns the privileges on Column of Tables Defined in the catalog That Are Available to, or granted by, a given user. (COLUMN_PRIVILEGES Rowset) TABLE_CATALOGTABLE_SCHEMATABLE_NAMECOLUMN_NAMEGRANTORGRANTEEadSchemaColumns4Returns the columns of tables (including views) defined in the catalog that are accessible to a given user. (COLUMNS Rowset) TABLE_CATALOGTABLE_SCHEMATABLE_NAMECOLUMN_NAMEadSchemaColumnsDomainUsage11Returns the columns defined in the catalog that are dependent on a domain defined in the catalog and owned by a given user. (COLUMN_DOMAIN_USAGE Rowset) DOMAIN_CATALOGDOMAIN_SCHEMADOMAIN_NAMECOLUMN_NAMEadSchemaConstraintColumnUsage6Returns the columns used by referential constraints, unique constraints, check constraints, and assertions, defined in the catalog and owned by a given user.

(CONSTRAINT_COLUMN_USAGE Rowset) TABLE_CATALOGTABLE_SCHEMATABLE_NAMECOLUMN_NAMEadSchemaConstraintTableUsage7Returns the tables that are used by referential constraints, unique constraints, check constraints, and assertions defined in the catalog and owned by a given user. (CONSTRAINT_TABLE_USAGE Rowset) TABLE_CATALOGTABLE_SCHEMATABLE_NAMEadSchemaCubes32Returns information about the available cubes in a schema (or the catalog , if the provider does not support schemas) (CUBES Rowset *) CATALOG_NAMESCHEMA_NAMECUBE_NAMEadSchemaDBInfoKeywords30Returns a list of provider-specific keywords (IDBInfo :: GetKeywords *) adSchemaDBInfoLiterals31Returns a list of provider-specific literals used in text commands (IDBInfo...: :.. GetLiteralInfo *) adSchemaDimensions33Returns information about the dimensions in a given cube It has one row for each dimension (DIMENSIONS Rowset *) CATALOG_NAMESCHEMA_NAMECUBE_NAMEDIMENSION_NAMEDIMENSION_UNIQUE_NAMEadSchemaForeignKeys27Returns the foreign key columns define d in the catalog by a given user. (FOREIGN_KEYS Rowset) PK_TABLE_CATALOGPK_TABLE_SCHEMAPK_TABLE_NAMEFK_TABLE_CATALOGFK_TABLE_SCHEMAFK_TABLE_NAMEadSchemaHierarchies34Returns information about the hierarchies available in a dimension. (HIERARCHIES Rowset *) CATALOG_NAMESCHEMA_NAMECUBE_NAMEDIMENSION_UNIQUE_NAMEHIERARCHY_NAMEHIERARCHY_UNIQUE_NAMEadSchemaIndexes12Returns the indexes defined in the catalog that are owned by a given user. (INDEXES Rowset) TABLE_CATALOGTABLE_SCHEMAINDEX_NAMETYPETABLE_NAMEadSchemaKeyColumnUsage8Returns the columns Defined in the catalog That Are Constrained as keys by a given user.

(KEY_COLUMN_USAGE Rowset) CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMETABLE_CATALOGTABLE_SCHEMATABLE_NAMECOLUMN_NAMEadSchemaLevels35Returns information about the levels available in a dimension. (LEVELS Rowset *) CATALOG_NAMESCHEMA_NAMECUBE_NAMEDIMENSION_UNIQUE_NAMEHIERARCHY_UNIQUE_NAMELEVEL_NAMELEVEL_UNIQUE_NAMEadSchemaMeasures36Returns information about the available measures. (MEASURES Rowset *) CATALOG_NAMESCHEMA_NAMECUBE_NAMEMEASURE_NAMEMEASURE_UNIQUE_NAMEadSchemaMembers38Returns information about the available members. (MEMBERS Rowset *) CATALOG_NAMESCHEMA_NAMECUBE_NAMEDIMENSION_UNIQUE_NAMEHIERARCHY_UNIQUE_NAMELEVEL_UNIQUE_NAMELEVEL_NUMBERMEMBER_NAMEMEMBER_UNIQUE_NAMEMEMBER_CAPTIONMEMBER_TYPETree operator (For more information, see the OLE DB for OLAP documentation.) adSchemaPrimaryKeys28Returns the primary key columns defined in the catalog by a given user. (pRIMARY_KEYS Rowset) PK_TABLE_CATALOGPK_TABLE_SCHEMAPK_TABLE_NAMEadSchemaProcedureColumns29Returns information about the colu mns of rowsets returned by procedures. (PROCEDURE_COLUMNS Rowset) PROCEDURE_CATALOGPROCEDURE_SCHEMAPROCEDURE_NAMECOLUMN_NAMEadSchemaProcedureParameters26Returns information about the parameters and return codes of procedures. (PROCEDURE_PARAMETERS Rowset) PROCEDURE_CATALOGPROCEDURE_SCHEMAPROCEDURE_NAMEPARAMETER_NAMEadSchemaProcedures16Returns the procedures defined in the catalog that are owned by a given user. (PROCEDURES Rowset) PROCEDURE_CATALOGPROCEDURE_SCHEMAPROCEDURE_NAMEPROCEDURE_TYPEadSchemaProperties37Returns information about the available Properties for Each Level of the Dimension.

(PROPERTIES Rowset *) CATALOG_NAMESCHEMA_NAMECUBE_NAMEDIMENSION_UNIQUE_NAMEHIERARCHY_UNIQUE_NAMELEVEL_UNIQUE_NAMEMEMBER_UNIQUE_NAMEPROPERTY_TYPEPROPERTY_NAMEadSchemaProviderSpecific-1Used if the provider defines its own nonstandard schema queries. adSchemaProviderTypes22Returns the (base) data types supported by the data provider. (PROVIDER_TYPES Rowset) DATA_TYPEBEST_MATCHAdSchemaReferentialConstraints9Returns the referential constraints defined in the catalog that are owned by a given user. (REFERENTIAL_CONSTRAINTS Rowset) CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMEadSchemaSchemata17Returns the schemas (database objects) that are owned by a given user. (SCHEMATA Rowset) CATALOG_NAMESCHEMA_NAMESCHEMA_OWNERadSchemaSQLLanguages18Returns the conformance levels, options, and dialects supported by the SQL-implementation processing data defined in the catalog. (SQL_LANGUAGES ROWSET) adschemastatics19returns the statistics defined in the catalog That Are Owned by a given user. (STATISTICS Rowset) TABLE_CATALOGTABLE_SCHEMATABLE_NAMEadSchemaTableConstraints10Returns the table constraints defined in the catalog that are owned by a given user. (TABLE_CONSTRAINTS Rowset) CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMETABLE_CATALOGTABLE_SCHEMATABLE_NAMECONSTRAINT_TYPEadSchemaTablePrivileges14Returns the privileges on tables defined in the catalog that are available to, or granted by, a given user. (Table_Privileges Rowset) Table_catalogTable_schematable_namegrantorgranteeeadschematables20Returns the tables (include Views) Defined in the catalog That Are Accessible to a given user.