Contains one row for each column of every table in the database.

The following table provides details of the SYSCOLUMNS table.

Table 1. SYSCOLUMNS core system table
Column name Column data type Column size
charset VARCHAR 32
col VARCHAR 32
collation VARCHAR 32
coltype VARCHAR 10
dflt_value VARCHAR 250
id INTEGER 4
nullflag VARCHAR 1
owner VARCHAR 32
scale INTEGER 4
tbl VARCHAR 32
width INTEGER 4