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. |
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)
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |