RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
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
};

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!