Announcing our $3.4M seed round 🚀 Read more →

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;

Ready for a modern SQL editor?