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 tableFor each column in the SYSVIEWS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents. 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