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