The following table shows the contents of the SYSVIEWS system table.
SYSVIEWS system table
For each column in the SYSVIEWS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents.
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
true
ID of the schema containing the view