Column name
|
Data type
|
Description
|
---|---|---|
ID
|
INTEGER
|
Unique column identifier.
|
REL_ID
|
INTEGER
|
The relation identifier as in SYS_TABLES.
|
COLUMN_NAME
|
WVARCHAR
|
The name of the column.
|
COLUMN_NUMBER
|
INTEGER
|
The number of the column in the table (in creation order).
|
DATA_TYPE
|
WVARCHAR
|
The data type of the column.
|
SQL_DATA_TYPE_NUM
|
SMALLINT
|
ODBC compliant data type number.
|
DATA_TYPE_NUMBER
|
INTEGER
|
Internal data type number.
|
CHAR_MAX_LENGTH
|
INTEGER
|
Maximum length for a CHAR field.
|
NUMERIC_PRECISION
|
INTEGER
|
Numeric precision.
|
NUMERIC_PREC_RADIX
|
SMALLINT
|
Numeric precision radix.
|
NUMERIC_SCALE
|
SMALLINT
|
Numeric scale.
|
NULLABLE
|
CHAR
|
Are NULL values allowed (Yes, No).
|
NULLABLE_ODBC
|
SMALLINT
|
ODBC, are NULL values allowed (1,0).
|
FORMAT
|
WVARCHAR
|
Reserved for future use.
|
DEFAULT_VAL
|
WVARCHAR
|
Current default value (if set).
|
ATTR_TYPE
|
INTEGER
|
User defined (0) or internal (>0).
|
REMARKS
|
LONG WVARCHAR
|
Reserved for future use.
|