Name
DROP VIEW -- Removes an existing view from a database.
Synopsis
DROP VIEW name [, ...]
Parameters
- name
The name of the view you wish to remove.
Results
- DROP
The message returned when a view is successfully dropped.
- ERROR: view "name" does not exist
The error returned if the view name does not exist in the current database.
Description
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.
Example
The following example removes the h_ publishers view from the booktown database:
booktown=# DROP VIEW h_ publishers;
DROP