Removes an existing view from a database.
DROP VIEW name [, ...]
The name of the view you wish to remove.
The message returned when a view is successfully dropped.
ERROR: view "
" does not exist
The error returned if the view
namedoes not exist in the current database.
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=# DROP VIEW h_publishers; DROP