1DROP VIEW(7)                     SQL Commands                     DROP VIEW(7)
2
3
4

NAME

6       DROP VIEW - remove a view
7
8

SYNOPSIS

10       DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

14       DROP  VIEW  drops an existing view. To execute this command you must be
15       the owner of the view.
16

PARAMETERS

18       IF EXISTS
19              Do not throw an error if the view does not exist.  A  notice  is
20              issued in this case.
21
22       name   The name (optionally schema-qualified) of the view to remove.
23
24       CASCADE
25              Automatically  drop  objects  that  depend  on the view (such as
26              other views).
27
28       RESTRICT
29              Refuse to drop the view if any objects depend on it. This is the
30              default.
31

EXAMPLES

33       This command will remove the view called kinds:
34
35       DROP VIEW kinds;
36
37

COMPATIBILITY

39       This  command  conforms  to  the SQL standard, except that the standard
40       only allows one view to be dropped per command, and apart from  the  IF
41       EXISTS option, which is a PostgreSQL extension.
42

SEE ALSO

44       ALTER VIEW [alter_view(7)], CREATE VIEW [create_view(7)]
45
46
47
48SQL - Language Statements         2011-09-22                      DROP VIEW(7)