How to Drop a View in Redshift

To drop a Redshift view, use the DROP VIEW command:

DROP VIEW view_name;

You can also add the IF EXISTS option to prevent errors when trying to drop a non-existent view.

DROP VIEW IF EXISTS view_name;