The SYSVIEWS table describes the view definitions within the current database.
The following table shows the contents of the 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 |