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  View and modify current_schema and search_path in Redshift database