When a materialized view is no longer needed, you can drop it.
Before you can drop a materialized view, you must drop or disable all dependent views. To determine whether there are views dependent on a materialized view, use the sa_dependent_views system procedure. See sa_dependent_views system procedure.
See also View dependencies.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the view.
In the left pane, double-click Views.
Right-click the materialized view and choose Delete.
Connect to the database as a user with DBA authority, or as the owner of the view.
Execute a DROP MATERIALIZED VIEW statement.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|