Displaying materialized views in a schema

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, select Database > My Systems > Catalogs > Schemas.
  3. In the right pane, click the Materialized Views tab or click the Materialized Views folder in the navigation tree.
    The following materialized view attributes appear in the right pane.

    • Name

      • The name of the materialized view. Click the name to view the details of the MV.

    • Metadata UID

      • A unique identification number of the materialized view.

    • Creation Time

      • Specifies the time and date when the materialized view is created.

    • Redefinition Time

      • Specifies the time and date when the materialized view is last redefined.