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 live online training, plus books, videos, and digital content from nearly 200 publishers.