SYSVIEWS system table
Derby Reference Manual
239
SYSVIEWS system table
The SYSVIEWS table describes the view definitions within the current database.
The following table shows the contents of the SYSVIEWS system table.
Table 61.
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
false
ID of the schema
containing the view
