Restrictions Argument Members

The optional Restrictions parameter allows the output to be filtered by specifying a member of the SchemaEnum enumeration. For example, a Recordset object can be filtered to return only a single table or view. The available members and their constraints as described in the following table.

SchemaEnum Member Restrictions

Member

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

SchemaEnum Member Restrictions (continued)

Member

Constraint Columns

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

Table continues on the next page

Table continues on the next page

SchemaEnum Member Restrictions (continued)

Member

Constraint Columns adSchemaIndexes adSchemaLevels adSchemaMeasures adSchemaMembers adSchemaPrimaryKeys

TABLE_CATALOG TABLE_SCHEMA INDEX_NAME TYPE

TABLE_NAME

adSchemaKeyColumnUsage

CONSTRAINT_CATALOG

CONSTRAINT_SCHEMA

CONSTRAINT_NAME

TABLE_CATALOG

TABLE_SCHEMA

TABLE_NAME

COLUMN_NAME

CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

DIMENSION_UNIQUE_NAME HIERARCHY_UNIQUE_NAME LEVEL_NAME LEVEL_UNIQUE_NAME

CATALOG_NAME

SCHEMA_NAME

CUBE_NAME

MEASURE_NAME

MEASURE_UNIQUE_NAME

adSchemaProcedureColumns

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.)

PK_TABLE_CATALOG

PK_TABLE_SCHEMA

PK_TABLE_NAME

PROCEDURE_CATALOG PROCEDURE_SCHEMA PROCEDURE_NAME COLUMN_NAME

SchemaEnum Member Restrictions (continued)

Member

Constraint Columns

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

Table continues on the next page

SchemaEnum Member Restrictions (continued)

Member

Constraint Columns

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

0 0

Post a comment