Show: Delphi C++
Display Preferences

Data.Win.ADODB.TSchemaInfo

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

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 DECLSPEC_DENUM TSchemaInfo : unsigned char { 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 };

Properties

Type Visibility Source Unit Parent
enum public
Data.Win.ADODB.pas
Data.Win.ADODB.hpp
Data.Win.ADODB Data.Win.ADODB

Description

TSchemaInfo values indicate the type of schema information to retrieve.

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



See Also

Personal tools
Translations