DataTypesColumns Class

Column names for result table from the built-in stored procedure DB_ADMIN.GET_DATATYPES. and DataStoreConnection.GetSchema(MetaDataCollectionName.DataTypes).

Class Hierarchy

Pascal

DataTypesColumns = class;

C++

class DataTypesColumns;

File

DataTypesColumns.cs

Description

DataTypesColumns provides the column names for the result table from the built-in stored procedure DB_ADMIN.GET_DATATYPES and DataStoreConnection.GetSchema(MetaDataCollectionName.DataTypes).

Each row in the result table of DB_ADMIN.GET_DATATYPES describes a data type. The columns of the result table are:

Constant	Description
TypeName	Used to access the TypeName column in the DataTypes metadata collection. The data in this column specifies the database specific data type name.
DbxDataType	Used to access the DbxDataType column in the DataTypes metadata collection. The data in this column specifies the DBX data type.
ColumnSize	Used to access the ColumnSize column in the DataTypes metadata collection. The data in this column specifies 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	Used to access the CreateFormat column in the DataTypes metadata collection. The data in this column specifies the create format as used in CREATE TABLE.
CreateParameters	Used to access the CreateParameters column in the DataTypes metadata collection. The data in this column specifies the parameters for the create format.
DataType	Used to access the DataType column in the DataTypes metadata collection. The data in this column specifies the name of the language type representing this data type.
IsAutoIncrementable	Used to access the IsAutoIncrementable column in the DataTypes metadata collection. The data in this column specifies that the data type can be used as for an autoincrement column.
IsBestMatch	Used to access the IsBestMatch column in the DataTypes metadata collection. The data in this column specifies that the data type is the best match for the language type.
IsCaseSensitive	Used to access the IsCaseSensitive column in the DataTypes metadata collection. The data in this column specifies that the data type is case sensitive.
IsFixedLength	Used to access the IsFixedLength column in the DataTypes metadata collection. The data in this column specifies that the data type is fixed length.
IsFixedPrecisionScale	Used to access the IsFixedPrecisionScale column in the DataTypes metadata collection. The data in this column specifies that the data type is an exact numeric.
IsLong	Used to access the IsLong column in the DataTypes metadata collection. The data in this column specifies that the data type is a blob type.
IsNullable	Used to access the IsNullable column in the DataTypes metadata collection. The data in this column specifies that the data type can be assigned a value of NULL.
IsSearchable	Used to access the IsSearchable column in the DataTypes metadata collection. The data in this column specifies that the data type can be searched in the SQL database.
IsSearchableWithLike	Used to access the IsSearchableWithLike column in the DataTypes metadata collection. The data in this column specifies that the data type can be search with the SQL LIKE operator.
IsUnsigned	Used to access the IsUnsigned column in the DataTypes metadata collection. The data in this column specifies that the data type is an unsigned numeric.
MaximumScale	Used to access the MaximumScale column in the DataTypes metadata collection. The data in this column specifies the maximum possible scale value.
MinimumScale	Used to access the MinimumScale column in the DataTypes metadata collection. The data in this column specifies the minimum possible scale value.
IsConcurrencyType	Used to access the IsConcurrencyType column in the DataTypes metadata collection. The data in this column specifies that the data type has special update semantics.
MaximumVersion	Used to access the MaximumVersion column in the DataTypes metadata collection. The data in this column specifies the last database product version where this type was avaliable.
MinimumVersion	Used to access the MinimumVersion column in the DataTypes metadata collection. The data in this column specifies the first database product version where this type was available.
IsLiteralSupported	Used to access the IsLiteralSupported column in the DataTypes metadata collection. The data in this column specifies that the data type can be represented as a SQL literal.
LiteralPrefix	Used to access the LiteralPrefix column in the DataTypes metadata collection. The data in this column specifies the prefix of a SQL literal.
LiteralSuffix	Used to access the LiteralSuffix column in the DataTypes metadata collection. The data in this column specifies the suffix of a SQL literal.
IsUnicode	Used to access the IsUnicode column in the DataTypes metadata collection. The data in this column specifies that the data type can hold unicode character data.
ProviderDbType	Used to access the ProviderDbType column in the DataTypes metadata collection. The data in this column specifies a SQLDataStore data type from the constants in Borland.Data.DataStore.JdsType. Reserved for .NET applications.