A superset of information in the SYSTABLES core system table.

The following table provides details of the SYSTABLES_FULL table.

Table 1. SYSTABLES_FULL system table
Column name Column data type Column size
can_dump VARCHAR 126
can_load VARCHAR 126
creator VARCHAR 32
description VARCHAR 144
dump_name VARCHAR 16
file_label VARCHAR 60
file_label_sa VARCHAR 12
frozen BIT 1
has_ccnstrs VARCHAR 1
has_fcnstrs VARCHAR 1
has_pcnstrs VARCHAR 1
has_ucnstrs VARCHAR 1
hidden BIT 1
id INTEGER 4
last_change INTEGER 4
owner VARCHAR 32
prime_index INTEGER 4
rssid INTEGER 4
segid INTEGER 4
tbl VARCHAR 32
tbltype VARCHAR 1
tbl_status VARCHAR 1
user_misc VARCHAR 20
valexp VARCHAR 144
valmsg VARCHAR 144
valmsg_sa VARCHAR 12