SYSVIEWS

Describes the view definitions in the distributed system.

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