How to drop a materialized view in Redshift database

Use the below command to drop a materialized view where mv_name is the name of the materialized view.

DROP MATERIALIZED VIEW mv_name;

See also  How to Refresh a Materialized View in Redshift