Contains one row for each table in the database.

The following table provides details of the SYSTABLES table.

Table 1. SYSTABLES core system table
Column name Column data type Column size
creator VARCHAR 32
has_ccnstrs VARCHAR 1
has_fcnstrs VARCHAR 1
has_pcnstrs VARCHAR 1
has_ucnstrs VARCHAR 1
id INTEGER 4
owner VARCHAR 32
rssid INTEGER 4
segid INTEGER 4
tbl VARCHAR 32
tbl_status VARCHAR 1
tbltype VARCHAR 1