Syntax

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

Rückgabewert

Typ

Beschreibung

ADODB.Recordset

Recordset-Objekt

Parameter

Verwendung

Name

Typ

Übergabe

Beschreibung

Erforderlich

Schema

ConnSchema

ByVal

Gewünschte Schema-Information

Optional

Criteria

Variant

ByVal

Einschränkendes Kriterium

Optional

SchemaID

Variant

ByVal

Provider-spezifisches Kriterium

ConnSchema

Criteria

41 – CSCActions

Unbekannt

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

Unbekannt

6 – CSCConstraintColumnUsage

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME

7 – CSCConstraintTableUsage

TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME

32 – CSCCubes

Unbekannt

30 – CSCDBInfoKeywords

Unbekannt

31 – CSCDBInfoLiterals

Unbekannt

33 – CSCDimensions

Unbekannt

27 – CSCForeignKeys

PK_TABLE_CATALOG, PK_TABLE_SCHEMA, PK_TABLE_NAME, FK_TABLE_CATALOG, FK_TABLE_SCHEMA, FK_TABLE_NAME

40 – CSCFunctions

Unbekannt

34 – CSCHierarchies

Unbekannt

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

Unbekannt

36 – CSCMeasures

Unbekannt

38 – CSCMembers

Unbekannt

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

Unbekannt

-1 – CSCProviderSpecific

Siehe 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

Unbekannt

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

Unbekannt

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