Name
DROP VIEW
-- Removes an existing view from a database.
Synopsis
DROP VIEW name [, ...]
Parameters
- name
The sole parameter of this command is the name of the existing table you wish to remove.
Results
- DROP
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.
Description
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.
Examples
This example will remove the high_id view.
DROP VIEW high_id;