You can control whether a materialized view is available for querying by enabling and disabling it.
You must be the owner of the materialized view or have one of the following system privileges:
To enable a materialized view, you must also have the SELECT privilege on the underlying table(s) or the SELECT ANY TABLE system privilege.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, double-click Views.
|Enable a materialized view||
|Disable a materialized view||Right-click the view and click Disable.|
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|