Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » Views » System views


SYSMVOPTION system view

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 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 at the time that the materialized view was created.
Constraints on underlying system table

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)

See also