typedef enum tagsqlDataType
{
sqlString = 0,
sqlInteger = 1,
sqlDouble = 2,
sqlBoolean = 3,
sqlBinaryData = 4,
sqlDateTime = 5
} sqlDataType
interface ICatalogStatement: IResultSetStatement
{
[propget, id(0x00000003), helpstring("True if the data type is supported.")]
HRESULT _stdcall DataTypeSupported([in] sqlDataType DataType, [out, retval] VARIANT_BOOL * Value );
[id(0x00000005), helpstring("Initiates enumeration of tables (, views & so on).")]
HRESULT _stdcall Tables([in] BSTR CatalogName, [in] BSTR SchemaName, [in] BSTR TableName, [in] BSTR TableType );
[id(0x00000007), helpstring("Initiates enumeration of properties of specified column(s).")]
HRESULT _stdcall Columns([in] BSTR CatalogName, [in] BSTR SchemaName, [in] BSTR TableName, [in] BSTR ColumnName );
[id(0x00000008), helpstring("Initiates enumeration of statistics data of specified table.")]
HRESULT _stdcall Statistics([in] BSTR CatalogName, [in] BSTR SchemaName, [in] BSTR TableName, [in] VARIANT_BOOL AllIndexes );
[id(0x00000009), helpstring("Initiates enumeration of primary keys of specified table.")]
HRESULT _stdcall PrimaryKeys([in] BSTR CatalogName, [in] BSTR SchemaName, [in] BSTR TableName );
[id(0x0000000A), helpstring("Initiates enumeration of foreign keys of specified table.")]
HRESULT _stdcall ForeignKeys([in] BSTR PKCatalogName, [in] BSTR PKSchemaName, [in] BSTR PKTableName, [in] BSTR FKCatalogName, [in] BSTR FKSchemaName, [in] BSTR FKTableName );
[id(0x0000000B), helpstring("Initiates enumeration of supported data types.")]
HRESULT _stdcall DataTypes( void );
}
The object implementing the ICatalogStatement interface gives an access to the database catalog data. All methods act as an SQL statement execution; i.e. each method generates a result set containing asked catalog data. The only exception to this rule is the DataTypeSupported property. Because Sequel uses a set of standard data types mapped to the driver specific data types, it could be difficult for you to find whether a certain data type is supported or not. For this reason the DataTypeSupported property is implemented.