Column Information | Data Type | Description |
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. |