Use the below command to drop a materialized view where mv_name is the name of the materialized view.
DROP MATERIALIZED VIEW mv_name;
Use the below command to drop a materialized view where mv_name is the name of the materialized view.
DROP MATERIALIZED VIEW mv_name;