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 |