Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Working with Database Objects » Working with views » Working with materialized views

Hiding materialized views Next Page

Dropping materialized views

When a materialized view is no longer needed, you can drop it.

Materialized view deletions and view dependencies

If you drop a materialized view, all views dependent upon it become INVALID. To use the dependent views, you need to either change the definition for the dependent views, or recreate the dropped materialized view.

To determine whether there are views dependent on a materialized view, use the sa_dependent_views system procedure. See sa_dependent_views system procedure.

For information on how dropping materialized views affects view alterations, see View dependencies.

To drop a materialized view (Sybase Central)
  1. Connect to the database as the DBA, or as the owner of the view.

  2. Open the Views folder for that database.

  3. Select the materialized view and then choose File > Delete.

To drop a materialized view (SQL)
  1. Connect to the database as the DBA, or as the owner of the view.

  2. Execute a DROP MATERIALIZED VIEW statement.

  3. Example

    The following statement drops the EmployeeConfidential materialized view.

    DROP MATERIALIZED VIEW EmployeeConfidential;
    See also