Contains information on each data type supported by the database.

The following table provides details of the SYSDATATYPES table.

Table 1. SYSDATATYPES system table
Column name Column data type Column size
autoincr SMALLINT 2
casesensitive SMALLINT 2
createparams VARCHAR 32
datatype SMALLINT 2
dhtypename VARCHAR 32
literalprefix VARCHAR 1
literalsuffix VARCHAR 1
localtypename VARCHAR 1
nullable SMALLINT 2
odbcmoney SMALLINT 2
searchable SMALLINT 2
typeprecision INTEGER 4
unsignedattr SMALLINT 2