TDBXDataTypesColumns Class

Accesses columns by name in the DataTypes metadata.

Pascal

TDBXDataTypesColumns = class;

C++

class TDBXDataTypesColumns;

File

DBXMetaDataNames

Description

TDBXDataTypesColumns is used to access columns by name in the DataTypes metadata collection. These columns are returned when TDBXCommand.Text is TDBXMetaDataCommands.GetDataTypes when reading metadata. To retrieve metadata columns, use these constants to index the TDBXReader instance returned by TDBXCommand.ExecuteQuery.

This table describes the columns.

Column Name	Data Type of Column Data	Description
TypeName	String	Database specific data type name.
DbxDataType	Int32	dbExpress data type.
ColumnSize	Int64	Length of this type. For a string data type, this is the maximum number of characters. For a floating point number, this is the number of significant bits in the mantissa. For other numeric types, this is the maximum number of significant digits. For date, time, and timestamp types, this is the length of the string representation.
CreateFormat	String	Create format as used in CREATE TABLE.
CreateParameters	String	Parameters for the create format.
DataType	String	Name of language type representing this data type.
IsAutoIncrementable	Boolean	Can be used for an autoincrement column.
IsBestMatch	Boolean	Is best match for language type.
IsCaseSensitive	Boolean	Is case sensitive.
IsFixedLength	Boolean	Is fixed length.
IsFixedPrecisionScale	Boolean	Is an exact numeric.
IsLong	Boolean	Is a BLOB type.
IsNullable	Boolean	Can be assigned a value of NULL.
IsSearchable	Boolean	Can be searched in the SQL database.
IsSearchableWithLike	Boolean	Can be searched with the SQL LIKE operator.
IsUnsigned	Boolean	Is an unsigned numeric.
MaximumScale	Int16	Maximum possible scale value.
MinimumScale	Int16	Minimum possible scale value.
IsConcurrencyType	Boolean	Has special update semantics.
MaximumVersion	String	Last database product version where this type was available.
MinimumVersion	String	First database product version where this type was available.
IsLiteralSupported	Boolean	Can be represented as a SQL literal.
LiteralPrefix	String	Prefix of SQL literal.
LiteralSuffix	String	Suffix of SQL literal.
IsUnicode	Boolean	Can hold Unicode character data.
ProviderDbType	Int32	Same as the DbxDataType column. Reserved for .NET applications.