ADO: ActiveX Data Objects

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