SYSMVOPTIONNAME system view

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.

Constraints on underlying system table

PRIMARY KEY (option_id)
UNIQUE Index (option_name)