Removes an existing view from a database.
DROP VIEW name [, ...]
name
The name of the view you wish to remove.
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.
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
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.