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;
Previous
How to Create a ViewShared queries and folders ✅ Version history ✅ One-click connection to Redshift ✅
Get more done, together, with PopSQL and Redshift