Column name
|
Data type
|
Description
|
VIEW_SYSID
|
INTEGER
|
System identifier of the view. |
CHECK_OPTION
|
CHAR(20)
|
One of:
"CASCADED"
"LOCAL"
"NONE". |
IS_UPDATABLE
|
CHAR(3)
|
One of:
"NO" = The view can not be updated
"YES" = The view can be updated. |
IS_INSTEAD_OF
|
CHAR(3)
|
One of:
"NO" = The view can be updated per se
"YES" = The view can be updated due to the existence of an instead of trigger. |
VIEW_DEFINITION
|
VARCHAR(2000)
|
The text of the view definition. |
