Viewing materialized view properties

Procedure

Log on to the NonStop SQL/MX Database Manager.
In the navigation tree, select Database > My Systems > Catalogs > Schemas > Materialized Views.
Select the required materialized view.

Viewing materialized views

The right pane displays the following tabs:

Materialized view attributes

Displays the attributes information of the MV.
Materialized view partition properties

Displays the partition properties of the MV.
Materialized view related objects

Displays the relationships of the view with other objects.
DDL

Displays the SQL/MX statement used to create the materialized view.
Materialized view related privileges

Displays the privileges of the user for a materialized view.