SQL Guide : Database system tables and system views : System tables : SYS_COLUMNS
  
SYS_COLUMNS
This table lists all system table columns.
There are no owner or user viewing restrictions for viewing the system columns. This means that owners can view columns other than those they have created in this table and users with no access rights or with specific access rights can still view any system column in this table.
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.
See also
System tables