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.