|
Each row in the SYSMVOPTION system view describes the setting of one option value for a materialized view at the time of its creation. However, the description does not contain the option name for the option. The underlying system table for this view is ISYSMVOPTION.
| Column name | Column type | Column constraint |
|---|---|---|
| view_object_id | UNSIGNED BIGINT | NOT NULL |
| option_id | UNSIGNED INT | NOT NULL |
| option_value | LONG VARCHAR | NOT NULL |
view_object_id The object ID of the materialized view.
option_id A unique number identifying the option in the database. To see the option name, see the SYSMVOPTIONNAME system view.
option_value The value of the option at the time that the materialized view was created.
PRIMARY KEY (view_object_id, option_id)
FOREIGN KEY (view_object_id) references SYS.ISYSOBJECT (object_id)
FOREIGN KEY (option_id) references SYS.ISYSMVOPTIONNAME (option_id)