2 $PostgreSQL: pgsql/doc/src/sgml/ref/drop_view.sgml,v 1.21 2005/01/04 00:39:53 tgl Exp $
3 PostgreSQL documentation
6 <refentry id="SQL-DROPVIEW">
8 <refentrytitle id="SQL-DROPVIEW-TITLE">DROP VIEW</refentrytitle>
9 <refmiscinfo>SQL - Language Statements</refmiscinfo>
13 <refname>DROP VIEW</refname>
14 <refpurpose>remove a view</refpurpose>
17 <indexterm zone="sql-dropview">
18 <primary>DROP VIEW</primary>
23 DROP VIEW <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | RESTRICT ]
28 <title>Description</title>
31 <command>DROP VIEW</command> drops an existing view. To execute
32 this command you must be the owner of the view.
37 <title>Parameters</title>
41 <term><replaceable class="PARAMETER">name</replaceable></term>
44 The name (optionally schema-qualified) of the view to remove.
50 <term><literal>CASCADE</literal></term>
53 Automatically drop objects that depend on the view (such as
60 <term><literal>RESTRICT</literal></term>
63 Refuse to drop the view if any objects depend on it. This is
72 <title>Examples</title>
75 This command will remove the view called <literal>kinds</literal>:
83 <title>Compatibility</title>
86 This command conforms to the SQL standard, except that the standard only
87 allows one view to be dropped per command.
92 <title>See Also</title>
94 <simplelist type="inline">
95 <member><xref linkend="sql-createview" endterm="sql-createview-title"></member>
101 <!-- Keep this comment at the end of the file
106 sgml-minimize-attributes:nil
107 sgml-always-quote-attributes:t
110 sgml-parent-document:nil
111 sgml-default-dtd-file:"../reference.ced"
112 sgml-exposed-tags:nil
113 sgml-local-catalogs:"/usr/lib/sgml/catalog"
114 sgml-local-ecat-files:nil