Refresh Materialized View

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you build and submit a REFRESH MATERIALIZED VIEW statement, to replace the contents of a materialized view.

Platform Availability


Note: This action is only available against views created with the Is Materialized control selected. For more information, see Views Wizard (PostgreSQL).

To replace the contents of a materialized view

  1. Initiate an Refresh Materialized View action against a view. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the dialog:
Step Settings and tasks

Action options

If With No Data is selected, a WITH NO DATA clause is included in the generated DDL. No new data is generated and the materialized view will be in an unscannable state.


Review the referring and referred objects that will be automatically resolved when you execute this operation. For details, see Dependencies.


Displays the DDL that will execute the object action. For details, see Preview.

3. Finally, use the Execute button to create the object.