9. Understanding .NET Data Provider Connectivity : .NET Data Provider Classes : IngresDataReader Class : GetSchemaTable Columns Returned
 
Share this page                  
GetSchemaTable Columns Returned
The GetSchemaTable describes the column metadata of the IngresDataReader.
Note:  The column information is not necessarily returned in the order shown.
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.