TSchemaInfo values indicate the type of schema information to retrieve.
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 );
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 };
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.) |
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
|
What do you think about this topic? Send feedback!
|