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
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.