ColumnName

String

The name of the column, which reflects the renaming of the column in the command text (that is, the alias).

ColumnOrdinal

Int32

The number of the column, beginning with 1.

ColumnSize

Int32

Maximum possible length of a value in the column.

NumericPrecision

Int16

This is the maximum precision of the column if the column is a numeric data type; otherwise the value is null.

NumericScale

Int16

This is the number of decimal places in the column if the column is a numeric data type; otherwise the value is null.

DataType

Type

The .NET Framework data type of the column.

ProviderType

IngresType

The indicator of the column's data type

IsLong

Boolean

Set to true if the column contains a long varchar, long varbinary, or long nvarchar object; otherwise false.

AllowDBNull

Boolean

Set to true if the application can set the column to a null value or if the data provider cannot determine if the application can set the column to a null value. Set to false if it is known that the application is not permitted to set the column to a null. Note that a column value may be null even if the application is not permitted to set the null value.

IsReadOnly

Boolean

Set to true if it is known that the column cannot be modified; otherwise false.

IsRowVersion

Boolean

Set to true if column has a persistent row identifier that cannot be written to and serves only to identify the row. The .NET Data Provider always returns false.

IsUnique

Boolean

Set to true if no two rows in the table can have the same value in this column. Set to false if not unique or if uniqueness cannot be determined. Only set if ExecuteReader(CommandBehavior.KeyInfo) was called.

IsKey

Boolean

Set to true if this column is in the set of columns that, taken together, uniquely identify the row. Only set if ExecuteReader( CommandBehavior.KeyInfo ) was called.

IsAutoIncrement

Boolean

Set to true if the column assigns values to new rows in fixed increments. The .NET Data Provider always returns false.

BaseCatalogName

String

The name of the database catalog that contains the column. This value is null if the catalog name cannot be determined. The .NET Data Provider always returns a null value.

BaseSchemaName

String

The name of the database schema that contains the column. This value is null if the schema name cannot be determined. Only set if ExecuteReader(CommandBehavior.KeyInfo) was called.

BaseTableName

String

The name of the database table or view that contains the column. This value is null if the table name cannot be determined. Only set if ExecuteReader(CommandBehavior.KeyInfo) was called.

BaseColumnName

String

The name of the column in the database. This value is null if the column name cannot be determined. Only set if
ExecuteReader( CommandBehavior.KeyInfo ) was called.