PopSQL
To drop a Redshift view, use the DROP VIEW command:
DROP VIEW
DROP VIEW view_name;
You can also add the IF EXISTS option to prevent errors when trying to drop a non-existent view.
IF EXISTS
DROP VIEW IF EXISTS view_name;
Spread the word