1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="sql-commands.html"><LINK
18
TITLE="DROP USER MAPPING"
19
HREF="sql-dropusermapping.html"><LINK
22
HREF="sql-end.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="DROP USER MAPPING"
57
HREF="sql-dropusermapping.html"
66
TITLE="DROP USER MAPPING"
67
HREF="sql-dropusermapping.html"
111
>DROP VIEW -- remove a view</DIV
113
CLASS="REFSYNOPSISDIV"
121
>DROP VIEW [ IF EXISTS ] <TT
126
> [, ...] [ CASCADE | RESTRICT ]</PRE
139
> drops an existing view. To execute
140
this command you must be the owner of the view.
162
> Do not throw an error if the view does not exist. A notice is issued
175
> The name (optionally schema-qualified) of the view to remove.
185
> Automatically drop objects that depend on the view (such as
196
> Refuse to drop the view if any objects depend on it. This is
211
> This command will remove the view called <TT
216
CLASS="PROGRAMLISTING"
217
>DROP VIEW kinds;</PRE
229
> This command conforms to the SQL standard, except that the standard only
230
allows one view to be dropped per command, and apart from the
234
> option, which is a <SPAN
249
HREF="sql-alterview.html"
252
HREF="sql-createview.html"
260
SUMMARY="Footer navigation table"
271
HREF="sql-dropusermapping.html"
299
>DROP USER MAPPING</TD
305
HREF="sql-commands.html"
b'\\ No newline at end of file'