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

Dropping materialized views Next Page

Retrieving information about materialized views


General information

You can request information, such as the status of a materialized view, using the sa_materialized_view_info system procedure. See sa_materialized_view_info system procedure.

For more information statuses for materialized views, see View status.

Database options information

Using the name of the materialized view, the options that were stored for it at creation time can be obtained from the SYSMVOPTION system view using a query. For example, to find the options for the EmployeeConfidential materialized view, you could execute the following statement:

SELECT option_name, option_value
FROM SYSMVOPTION JOIN SYSMVOPTIONNAME
WHERE SYSMVOPTION.view_object_id=(
   SELECT object_id FROM SYSTAB
   WHERE table_name='EmployeeConfidential' )
ORDER BY option_name;
Dependency information

To determine the list of views dependent on a materialized view, use the sa_dependent_views system procedure. See sa_dependent_views system procedure.

This information can also be found in the SYSDEPENDENCY system view. See SYSDEPENDENCY system view.