Column Name 

Data Type 

Description 

CatalogName  

String  

The catalog name.  

SchemaName  

String  

The schema name.  

TableName  

String  

The table name.  

ColumnName  

String  

The column name.  

TypeName  

String  

The database specific data type name.  

Precision  

Int32  

The precision of this type. For a string data type, this is the maximum number of characters. For a decimal types, this is the maximum number digits including digits from the scale.  

Scale  

Int32  

The scale of a decimal type.  

Ordinal  

Int32  

The position in the rows of the table starting with 1.  

DefaultValue  

String  

The default value.  

IsNullable  

Boolean  

Can accept NULL values.  

IsAutoIncrement  

Boolean  

Is an autoincrement value.  

MaxInline  

Int32  

The maximal number of bytes to write into row. The rest of the data is handled as a blob (Blackfish SQL only).  

DbxDataType  

Int32  

The DBX data type.  

IsFixedLength  

Boolean  

Holds fixed length data.  

IsUnicode  

Boolean  

Can hold unicode characters.  

IsLong  

Boolean  

Is a blob data type.  

IsUnsigned  

Boolean  

Is an unsigned numeric type.