TypeName

String

Ingres data type name

ProviderDbType

INT32

IngresType value to be used for a parameter data type

ColumnSize

INT64

Length of the data type, if non-numeric

CreateFormat

String

Format string for creation of a column’s data type in a CREATE TABLE

CreateParameters

String

Length, precision, and/or scale parameters associated with the data type’s CreateFormat

DataType

String

Name of the .NET Framework data type associated with this data type

IsAutoIncrementable

Boolean

Indicates whether this data type may be auto-incrementing

IsBestMatch

Boolean

Indicates whether this data type is the best match for the .NET Framework specified by the DataType column

IsCaseSensitive

Boolean

Indicates whether the data type is a character data type and is case-sensitive

IsFixedLength

Boolean

Indicates whether the data type is of fixed length

IsFixedPrecisionScale

Boolean

Indicates whether the data type has a fixed precision and scale

IsLong

Boolean

Indicates whether the data type is a CLOB or BLOB

IsNullable

Boolean

Indicates whether the data type is nullable

IsSearchable

Boolean

Indicates whether the data type can be used in a WHERE predicate with any operator other than LIKE

IsSearchableWithLike

Boolean

Indicates whether the data type can be used in a WHERE predicate with the LIKE operator

IsUnsigned

Boolean

Indicates whether the data type is unsigned

MaximumScale

INT16

If the data type is numeric, the maximum number of digits to the right of the decimal point

MinimumScale

INT16

If the data type is numeric, the minimum number of digits to the right of the decimal point

IsConcurrencyType

Boolean

Indicates whether the data type is updated when the row is changed and the column value is different. DBNull.Value if this capability is not supported.

IsLiteralSupported

Boolean

Indicates whether the data type can be expressed in a literal

LiteralPrefix

String

The prefix for a literal of this type

LiteralSuffix

String

The suffix for a literal of this type