Materialized View#

Create#

Right-click on the materialized view in the database object tree and select New. Edit the materialized view statement and click OK to create the materialized view.

Edit#

Right-click on the materialized view in the database object tree and select Edit. Edit the materialized view statement and click OK to modify the materialized view.

Rename#

Right-click on the materialized view in the database object tree and select Rename. Enter the new materialized view name and click OK to complete the renaming.

Drop#

Right-click on the materialized view in the database object tree and select Drop. A confirmation pop-up will appear. Click OK to drop the materialized view.

Script#

View DDL#

Right-click on the materialized view in the database object tree and select Script -> View DDL. You can view and copy the DDL statement in the pop-up box.

Generate Select#

Right-click on the materialized view in the database object tree and select Script -> Generate Select.... View the statement in the pop-up box.