SYSVIEWS system table

Describes the view definitions within the current database.
Column Name Type Length Nullability Contents
TABLEID CHAR 36 false unique identifier for the view (called TABLEID since it is joined with column of that name in SYSTABLES)
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