Dropping a materialized view

You must understand when to drop a materialized view to successfully drop related tables.

Drop a materialized view before performing a DROP TABLE operation on a related table. You cannot drop a table that has a relationship with a materialized view.

In this task, you drop a materialized view named mv1 from the database named default.

Drop a materialized view in my_database named mv1 .
DROP MATERIALIZED VIEW default.mv;