January 2002
Intermediate to advanced
640 pages
16h 39m
English
Removes an existing view from a database.
DROP VIEW name [, ...]nameThe name of the view you wish to remove.
DROPThe message returned when a view is successfully dropped.
ERROR: view "name"
does not existThe error returned if the view name does not
exist in the current database.
Use the DROP VIEW command to remove a view from a database. As with
most objects, you must be the owner a view to remove it.
The following example removes the h_publishers view from the booktown database:
booktown=# DROP VIEW h_publishers;
DROP