Describes the view definitions within the current database.
| 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 |