DROP VIEW
DROP VIEW — Remove a view
Synopsis
DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Description
DROP VIEW removes an existing view. You must be the owner of the view to execute this command.
Parameters
IF EXISTS
Do not throw an error if the view does not exist. A notice is issued in this case.
name
The name of the view to remove (optionally schema-qualified).
CASCADE
Automatically drop objects that depend on the view (such as other views), and in turn all objects that depend on those objects.
RESTRICT
Refuse to drop the view if any objects depend on it. This is the default.
Examples
-- This command will remove the view named kinds:
DROP VIEW kinds;