DROP MATERIALIZED VIEW
You can avoid making a table name unusable by dropping a dependent materialized view before dropping a table.
DROP MATERIALIZED VIEW [db_name.]materialized_view_name;
- The database name followed by a name for the materialized view in dot notation.
Dropping a table that is used by a materialized view is not allowed and prevents you from creating another table of the same name. You must drop the materialized view before dropping the tables.
DROP MATERIALIZED VIEW mydb.mv1;