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