Each row in the SYSMVOPTION system view describes the setting of one option value for a materialized view or text index at the time of its creation. The name of the option can be found in the SYSMVOPTIONNAME system view. The underlying system table for this view is ISYSMVOPTION.
| Column name | Data type | Description |
|---|---|---|
| view_object_id | UNSIGNED BIGINT | The object ID of the materialized view. |
| option_id | UNSIGNED INT | A unique number identifying the option in the database. To see the option name, see the SYSMVOPTIONNAME system view. |
| option_value | LONG VARCHAR | The value of the option when 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)