DROP VIEW

Name

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