You can drop a materialized view from the database. Perform this task when you no longer need the materialized view, or when you have made a schema change to an underlying referenced object such that the materialized view definition is no longer valid.
You must have DBA authority, or be the owner of the view.
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.
Context and remarks
Use the SQL Anywhere 12 plug-in to connect to the database.
In the left pane, double-click Views.
Right-click the materialized view and click Delete.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|