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   false text of view definition
CHECKOPTION CHAR 1 false 'N' (check option not supported yet)
COMPILATION SCHEMAID CHAR 36 false id of the schema containing the view