info > DROP_VIEW(7)

man perldoc info pydoc3 ri search

📛 NAME

DROP_VIEW — remove a view

🚀 Quick Reference

Use Case	Command	Description
Drop a single view	DROP VIEW view_name;	Removes the view if it exists and you own it.
Drop view only if it exists	DROP VIEW IF EXISTS view_name;	No error if the view is missing; a notice is issued.
Drop view with all dependencies	DROP VIEW view_name CASCADE;	Automatically drops objects that depend on the view.
Drop multiple views	DROP VIEW view1, view2;	Removes several views in one command.

📋 Synopsis

DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

📝 Description

DROP VIEW drops an existing view. To execute this command you must be the owner of the view.

⚙️ Parameters

• IF EXISTS — 🛡️ Do not throw an error if the view does not exist. A notice is issued in this case.
• name — 🏷️ The name (optionally schema‑qualified) of the view to remove.
• CASCADE — 🔄 Automatically drop objects that depend on the view (such as other views), and in turn all objects that depend on those objects (see Section 5.14).
• RESTRICT — 🚫 Refuse to drop the view if any objects depend on it. This is the default.

💡 Examples

This command will remove the view called kinds:

DROP VIEW kinds;

🔗 Compatibility

This command conforms to the SQL standard, except that the standard only allows one view to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL extension.

📚 See Also

ALTER VIEW (ALTER_VIEW(7)), CREATE VIEW (CREATE_VIEW(7))

PostgreSQL 14.23 — 2026

📛 NAME 🚀 Quick Reference 📋 Synopsis 📝 Description ⚙️ Parameters 💡 Examples 🔗 Compatibility 📚 See Also