DROP VIEW can be used to remove a view.
Because a view is logical, this does not affect any data in any of the referenced tables.
The role must have the
DDL permission at the database level.
drop_view_statement ::= DROP VIEW [ IF EXISTS ] [schema_name.]view_name ; view_name ::= identifier schema_name ::= identifier
||Drop the view if it exists. Does not error if the view does not exist.|
||The name of the schema from which to drop the view.|
||The name of the view to drop.|
Dropping a table¶
DROP VIEW angry_animals;
Dropping a view (always succeeds)¶
farm=> DROP VIEW angry_animals; executed farm=> DROP VIEW angry_animals; View 'public.angry_animals' not found -- This will succeed, even though the view does not exist farm=> DROP VIEW IF EXISTS angry_animals; executed