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

Setting the optimizer staleness threshold for materialized views Next Page

Hiding materialized views

You can hide a materialized view's definition from users. When you hide a materialized view, you obfuscate the view definition stored in the database, making the view invisible in the catalog. The view can still be directly referenced, and is still eligible for use during query processing. When a materialized view is hidden, debugging using the debugger will not show the view definition, nor will the definition be available through procedure profiling, and the view can be still unloaded and reloaded into other databases.

Hiding a materialized view is irreversible, and can only be performed using SQL statements.

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

  2. Execute an ALTER MATERIALIZED VIEW statement with the SET HIDDEN clause.

  3. Example

    The following statement hides the EmployeeConfidential materialized view.

    See also