Each row in the SYSMVOPTION system view gives the name option value for a materialized view or text index at the time of its creation. The value for the option can be found in the SYSMVOPTION system view. The underlying system table for this view is ISYSMVOPTIONNAME.
| Column name | Data type | Description |
|---|---|---|
| option_id | UNSIGNED INT | A number uniquely identifying the option in the database. |
| option_name | CHAR(128) | The name of the option. |
PRIMARY KEY (option_id)
UNIQUE Index (option_name)