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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » Views » System views


SYSMVOPTION system view

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.
 Constraints on underlying system table
 See also