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 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)
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|