Name

SchemaEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

The SchemaEnum enumeration indicates the type of schema information that is returned from the OpenSchema method of the Connection object.

Table E-44. The SchemaEnum Enumeration

Enumeration (ADO/WFC)

Value

Description

adSchemaAsserts (ASSERTS)
0

Returns assertions for a catalog of a user. Constraint columns include:

  • CONSTRAINT_CATALOG

  • CONSTRAINT_SCHEMA

  • CONSTRAINT_NAME

adSchemaCatalogs (CATALOGS)
1

Returns the physical arguments associated with catalogs accessible from the data source. Constraint columns include:

  • CATALOG_NAME

adSchemaCharacterSets (CHARACTERSETS)
2

Returns the available character sets for a catalog of a user. Constraint columns include:

  • CHARACTER_SET_CATALOG

  • CHARACTER_SET_SCHEMA

  • CHARACTER_SET_NAME

adSchemaCheckConstraints (CHECKCONTRAINTS)
5

Returns the check constraints for a catalog of a user. Constraint columns include:

  • CONSTRAINT_CATALOG

  • CONSTRAINT_SCHEMA

  • CONSTRAINT_NAME

adSchemaCollations (COLLATIONS)
3

Returns the character collations for a catalog of a user. Constraint columns include:

  • COLLATION_CATALOG

  • COLLATION_SCHEMA

  • COLLATION_NAME

adSchemaColumnPrivileges (COLUMNPRIVILEGES)
13

Returns privileges for columns of tables in a catalog of -- or granted by -- a user. Constraint columns include:

  • TABLE_CATALOG

  • TABLE_SCHEMA

  • TABLE_NAME

  • COLUMN_NAME

  • GRANTOR

  • GRANTEE

adSchemaColumns (COLUMNS)
4

Returns columns of tables and views for a catalog of a user. Constraint columns include: ...

Get ADO: ActiveX Data Objects now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.