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.

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 NO ID of the schema containing the view

See Also