ADODB.TSchemaInfo Enumeration

TSchemaInfo values indicate the type of schema information to retrieve.

Pascal

TSchemaInfo = (
  siAsserts,
  siCatalogs,
  siCharacterSets,
  siCollations,
  siColumns,
  siCheckConstraints,
  siConstraintColumnUsage,
  siConstraintTableUsage,
  siKeyColumnUsage,
  siReferentialConstraints,
  siTableConstraints,
  siColumnsDomainUsage,
  siIndexes,
  siColumnPrivileges,
  siTablePrivileges,
  siUsagePrivileges,
  siProcedures,
  siSchemata,
  siSQLLanguages,
  siStatistics,
  siTables,
  siTranslations,
  siProviderTypes,
  siViews,
  siViewColumnUsage,
  siViewTableUsage,
  siProcedureParameters,
  siForeignKeys,
  siPrimaryKeys,
  siProcedureColumns,
  siDBInfoKeywords,
  siDBInfoLiterals,
  siCubes,
  siDimensions,
  siHierarchies,
  siLevels,
  siMeasures,
  siProperties,
  siMembers,
  siProviderSpecific
);

C++

enum TSchemaInfo {
  siAsserts,
  siCatalogs,
  siCharacterSets,
  siCollations,
  siColumns,
  siCheckConstraints,
  siConstraintColumnUsage,
  siConstraintTableUsage,
  siKeyColumnUsage,
  siReferentialConstraints,
  siTableConstraints,
  siColumnsDomainUsage,
  siIndexes,
  siColumnPrivileges,
  siTablePrivileges,
  siUsagePrivileges,
  siProcedures,
  siSchemata,
  siSQLLanguages,
  siStatistics,
  siTables,
  siTranslations,
  siProviderTypes,
  siViews,
  siViewColumnUsage,
  siViewTableUsage,
  siProcedureParameters,
  siForeignKeys,
  siPrimaryKeys,
  siProcedureColumns,
  siDBInfoKeywords,
  siDBInfoLiterals,
  siCubes,
  siDimensions,
  siHierarchies,
  siLevels,
  siMeasures,
  siProperties,
  siMembers,
  siProviderSpecific
};

File

ADODB

Description

Use TSchemaInfo values to specify the type of schema information to retrieve from a provider.

The constants that make up the TSchemaInfo type correspond directly to the ADO constants used for the QueryType parameter for the OpenSchema method of the ADO Connection object. For additional information on these ADO constants and their effects, see the Microsoft Data Access SDK help in the topic for the OpenSchema method of the ADO Connection object.

A TSchemaInfo value may be any of the constants below:

Schema Parameter Value	ADO Criteria Values
siProviderSpecific	The provider defines its own nonstandard schema queries outside those listed below.
siAsserts	CONSTRAINT_CATALOG
siCatalogs	CATALOG_NAME
siCharacterSets	CHARACTER_SET_CATALOG
siCollations	COLLATION_CATALOG
siColumns	TABLE_CATALOG
siCheckConstraints	CONSTRAINT_CATALOG
siConstraintColumnUsage	TABLE_CATALOG
siConstraintTableUsage	TABLE_CATALOG
siKeyColumnUsage	CONSTRAINT_CATALOG
siReferentialConstraints	CONSTRAINT_CATALOG
siTableConstraints	CONSTRAINT_CATALOG
siColumnsDomainUsage	DOMAIN_CATALOG
siIndexes	TABLE_CATALOG
siColumnPrivileges	TABLE_CATALOG
siTablePrivileges	TABLE_CATALOG
siUsagePrivileges	OBJECT_CATALOG
siProcedures	PROCEDURE_CATALOG
siSchemata	CATALOG_NAME
siSQLLanguages	None.
siStatistics	TABLE_CATALOG
siTables	TABLE_CATALOG
siTranslations	TRANSLATION_CATALOG
siProviderTypes	DATA_TYPE
siViews	TABLE_CATALOG
siViewColumnUsage	VIEW_CATALOG
siViewTableUsage	VIEW_CATALOG
siProcedureParameters	PROCEDURE_CATALOG
siForeignKeys	PK_TABLE_CATALOG
siPrimaryKeys	PK_TABLE_CATALOG
siProcedureColumns	PROCEDURE_CATALOG
siDBInfoKeywords	(Defined in OLE DB, but not supported by ADO.)
siDBInfoLiterals	(Defined in OLE DB, but not supported by ADO.)
siCubes	(Defined in OLE DB, but not supported by ADO.)
siDimensions	(Defined in OLE DB, but not supported by ADO.)
siHierarchies	(Defined in OLE DB, but not supported by ADO.)
siLevels	(Defined in OLE DB, but not supported by ADO.)
siMeasures	(Defined in OLE DB, but not supported by ADO.)
siProperties	(Defined in OLE DB, but not supported by ADO.)
siMembers	(Defined in OLE DB, but not supported by ADO.)