Syntax

OpenSchema(Schema [, Criteria] [, SchemaID])

Return value

Type

Description

ADODB.Recordset

Recordset object

Parameter

Use

Name

Type

Passing

Description

Required

Schema

ConnSchema

ByVal

Desired schema information

Optional

Criteria

Variant

ByVal

Restrictive criterion

Optional

SchemaID

Variant

ByVal

Provider-specific criterion

ConnSchema

Criteria

41 – CSCActions

Unknown

0 – CSCAsserts

CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME

1 – CSCCatalogs

CATALOG_NAME

2 – CSCCharacterSets

CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA,CHARACTER_SET_NAME

5 – CSCCheckConstraints

CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME

3 – CSCCollations

COLLATION_CATALOG, COLLATION_SCHEMA, COLLATION_NAME

13 – CSCColumnPriviledges

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, GRANTOR, GRANTEE

4 – CSCColumns

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME

11 – CSCColumnsDomainUsage

DOMAIN_CATALOG, DOMAIN_SCHEMA, DOMAIN_NAME, COLUMN_NAME

42 – CSCCommands

Unknown

6 – CSCConstraintColumnUsage

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME

7 – CSCConstraintTableUsage

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME

32 – CSCCubes

Unknown

30 – CSCDBInfoKeywords

Unknown

31 – CSCDBInfoLiterals

Unknown

33 – CSCDimensions

Unknown

27 – CSCForeignKeys

PK_TABLE_CATALOG, PK_TABLE_SCHEMA, PK_TABLE_NAME, FK_TABLE_CATALOG, FK_TABLE_SCHEMA, FK_TABLE_NAME

40 – CSCFunctions

Unknown

34 – CSCHierarchies

Unknown

12 – CSCIndexes

TABLE_CATALOG, TABLE_SCHEMA, INDEX_NAME, TYPE, TABLE_NAME

8 – CSCKeyColumnUsage

CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME

35 – CSCLevels

Unknown

36 – CSCMeasures

Unknown

38 – CSCMembers

Unknown

28 – CSCPrimaryKeys

PK_TABLE_CATALOG, PK_TABLE_SCHEMA, PK_TABLE_NAME

29 – CSCProcedureColumns

PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME, COLUMN_NAME

26 – CSCProcedureParameters

PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME, PARAMETER_NAME

16 – CSCProcedures

PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME, PARAMETER_TYPE

37 – CSCProperties

Unknown

-1 – CSCProviderSpecific

See SchemaID

22 – CSCProviderTypes

DATA_TYPE, BEST_MATCH

9 – CSCReferencialConstraints

CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME

17 – CSCSchemata

CATALOG_NAME, SCHEMA_NAME, SCHEMA_OWNER

43 – CSCSets

Unknown

18 – CSCSQLLanguages

None

19 – CSCStatistics

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME

10 – CSCTableConstraints

CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CONSTRAINT_TYPE

14 – CSCTablePriviledges

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, GRANTOR, GRANTEE

20 – CSCTables

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE

21 – CSCTranslations

TRANSLATION_CATALOG, TRANSLATION_SCHEMA, TRANSLATION_NAME

39 – CSCTrustees

Unknown

15 – CSCUsagePriviledges

OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, GRANTOR, GRANTEE

24 – CSCViewColumnUsage

VIEW_CATALOG, VIEW_SCHEMA, VIEW_NAME

23 – CSCViews

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME

25 – CSCViewTableUsage

VIEW_CATALOG, VIEW_SCHEMA, VIEW_NAME