| Column Name | Type | Length | Nullability | Contents |
|---|---|---|---|---|
| TABLEID | CHAR | 36 | false | unique identifier for the view (called TABLEID since it is joined with column of that name in SYSTABLES) |
| 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 |