SYSVIEWS system table The SYSVIEWS table describes the view definitions within the current database. system tablesSYSVIEWS viewsSYSVIEWS system table SYSVIEWS system table

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

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