ADO: ActiveX Data Objects

Name

Connection.OpenSchema — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

Set recordset = connection.OpenSchema(Schema, Criteria, SchemaID)

The OpenSchema method returns a Recordset object containing information about the data source’s schema.

Arguments

Schema (SchemaEnum)

Indicates the type of schema the OpenSchema method will provide in the returned Recordset object.

SchemaEnum contains the enumeration values listed in Table F-1.

Criteria (Variant Array)

Optional. Indicates which constraint columns to use for the Schema requested. A list of each available constraint column for each schema type is listed in Table G-1.

SchemaID (Long)

Optional. Represents a GUID of a provider-specific schema query. If the Schema parameter is set to adSchemaProviderSpecific (-1), then this parameter is mandatory; otherwise, it is not used.

Description

The OpenSchema method is used to obtain information about a data source’s structure -- its schema.

By setting the Schema parameter to a SchemaEnum value, ADO can determine which information the application is requesting. In addition, the Criteria parameter can be set to narrow the search. For instance, by passing the adSchemaTables enumeration value, the OpenSchema method will only return the table names.

Some providers may support their own schema query types. To use this feature, set the Schema parameter to adSchemaProviderSpecific, and set the SchemaID parameter to the GUID of the provider-specific schema query. If the Schema parameter is set to the adSchemaProviderSpecific ...