SYSVIEWS system table

The SYSVIEWS table describes the view definitions within the current database.

The following table shows the contents of the SYSVIEWS system table.

Table 1. SYSVIEWS system table
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