| 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 | false | text of view definition | |
| CHECKOPTION | CHAR | 1 | false | 'N' (check option not supported yet) |
| COMPILATION SCHEMAID | CHAR | 36 | false | id of the schema containing the view |