A superset of information in the SYSCOLUMNS core system table.

The following table provides details of the SYSCOLUMNS_FULL table.

Table 1. SYSCOLUMNS_FULL system table
Column name Column data type Column size
array_extent INTEGER 4
charset VARCHAR 32
col VARCHAR 32
collation VARCHAR 32
coltype VARCHAR 20
col_label VARCHAR 60
col_label_sa VARCHAR 12
col_subtype INTEGER 4
description VARCHAR 144
dflt_value VARCHAR 250
dflt_value_sa VARCHAR 12
display_order INTEGER 4
field_rpos INTEGER 4
format VARCHAR 60
format_sa VARCHAR 12
help VARCHAR 126
help_sa VARCHAR 12
id VARCHAR 4
label VARCHAR 60
label_sa VARCHAR 12
nullflag CHARACTER 2
owner VARCHAR 32
scale INTEGER 4
tbl VARCHAR 32
user_misc VARCHAR 20
valexp VARCHAR 144
valmsg VARCHAR 144
valmsg_sa VARCHAR 12
view_as VARCHAR 100
width INTEGER 4