The following table shows the contents of the SYSVIEWS system table.
SYSVIEWS system table
Column Name
Type
Length
Nullable
Contents
TABLEID
CHAR
36
false
Unique identifier for the view (join with
SYSTABLES.TABLEID)
VIEWDEFINITION
LONG VARCHAR
32,700
false
Text of view definition
CHECKOPTION
CHAR
1
false
'N' (check option not supported yet)
COMPILATIONSCHEMAID
CHAR
36
false
ID of the schema containing the view