RAD Studio VCL Reference
|
This metadata collection represents data types in a database.
const DataTypes: string = "DataTypes";
string DataTypes = "DataTypes";
This metadata collection represents the data types supported by a database.
The columns are:
Column Name |
Data Type |
Description |
The database specific data type name. |
The DBX data type. |
The database specific data type name. The 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 a date, time, and timestamp types, this is the length of the string representation. |
CreateFormat |
String |
The create format as used in CREATE TABLE. |
CreateParameters |
String |
The parameters for the create format. |
DataType |
String |
The name of the language type representing this data type. |
IsAutoIncrementable |
Boolean |
Can be used as for an autoincrement column. |
IsBestMatch |
Boolean |
Is the best match for the 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 |
The maximum possible scale value. |
MinimumScale |
Int16 |
The minimum possible scale value. |
IsConcurrencyType |
Boolean |
Has special update semantics . |
MaximumVersion |
String |
The last database product version where this type was available. |
MinimumVersion |
String |
The first database product version where this type was available. |
IsLiteralSupported |
Boolean |
Can be represented as a SQL literal. |
LiteralPrefix |
String |
The prefix of a SQL literal. |
LiteralSuffix |
String |
The suffix of a SQL literal. |
IsUnicode |
Boolean |
Can hold unicode character data. |
ProviderDb |
Int32 |
The same as the DbxDataType column. Reserved for .NET applications. |
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
|
What do you think about this topic? Send feedback!
|