TABLE_CATALOG1

String

Always DBNull.Value

TABLE_SCHEMA2

String

Schema name (table/view owner name)

TABLE_NAME3

String

Table/view name of user table

COLUMN_NAME4

String

Column name

ORDINAL_POSITION

Int16

Position of the column within the set of the table’s columns, numbered from 1

COLUMN_DEFAULT

String

Column’s default value

IS_NULLABLE

Boolean

Indicates whether the column is nullable

DATA_TYPE

String

Ingres data type name

CHARACTER_MAXIMUM
_LENGTH

INT32

Maximum length in characters, if character or binary data type

CHARACTER_OCTET
_LENGTH

INT32

Maximum length in bytes, if character or binary data type

NUMERIC_PRECISION

Byte

Precision length if an integer, float, real, decimal, datetime, or interval data type

NUMERIC_PRECISION
_RADIX

INT16

Radix of the Precision

NUMERIC_SCALE

INT32

Scale length

DATETIME_PRECISION

INT16

Precision of ingresdate and ANSI Timestamp data types