Data.DBXMetaDataNames.TDBXDataTypesColumns
Delphi
TDBXDataTypesColumns = class
C++
class PASCALIMPLEMENTATION TDBXDataTypesColumns : public System::TObject
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | Data.DBXMetaDataNames.pas Data.DBXMetaDataNames.hpp |
Data.DBXMetaDataNames | Data.DBXMetaDataNames |
Description
Accesses columns by name in the DataTypes metadata.
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. |