-- Removes an existing view from a database.
DROP VIEW name [, ...]
The sole parameter of this command is the name of the existing table you wish to remove.
The message is displayed if the view was successfully dropped.
- ERROR: view "name" does not exist
This message is displayed if the specified view does not exist in the current database.
Use the DROP VIEW command to remove an existing view from a database.
As with most objects, you must be the owner of the view to remove it.
This example will remove the high_id view.
DROP VIEW high_id;