<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/drop_view.sgml,v 1.21 2005/01/04 00:39:53 tgl Exp $ PostgreSQL documentation --> <refentry id="SQL-DROPVIEW"> <refmeta> <refentrytitle id="SQL-DROPVIEW-TITLE">DROP VIEW</refentrytitle> <refmiscinfo>SQL - Language Statements</refmiscinfo> </refmeta> <refnamediv> <refname>DROP VIEW</refname> <refpurpose>remove a view</refpurpose> </refnamediv> <indexterm zone="sql-dropview"> <primary>DROP VIEW</primary> </indexterm> <refsynopsisdiv> <synopsis> DROP VIEW <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | RESTRICT ] </synopsis> </refsynopsisdiv> <refsect1> <title>Description</title> <para> <command>DROP VIEW</command> drops an existing view. To execute this command you must be the owner of the view. </para> </refsect1> <refsect1> <title>Parameters</title> <variablelist> <varlistentry> <term><replaceable class="PARAMETER">name</replaceable></term> <listitem> <para> The name (optionally schema-qualified) of the view to remove. </para> </listitem> </varlistentry> <varlistentry> <term><literal>CASCADE</literal></term> <listitem> <para> Automatically drop objects that depend on the view (such as other views). </para> </listitem> </varlistentry> <varlistentry> <term><literal>RESTRICT</literal></term> <listitem> <para> Refuse to drop the view if any objects depend on it. This is the default. </para> </listitem> </varlistentry> </variablelist> </refsect1> <refsect1> <title>Examples</title> <para> This command will remove the view called <literal>kinds</literal>: <programlisting> DROP VIEW kinds; </programlisting> </para> </refsect1> <refsect1> <title>Compatibility</title> <para> This command conforms to the SQL standard, except that the standard only allows one view to be dropped per command. </para> </refsect1> <refsect1> <title>See Also</title> <simplelist type="inline"> <member><xref linkend="sql-createview" endterm="sql-createview-title"></member> </simplelist> </refsect1> </refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:nil sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t sgml-indent-step:1 sgml-indent-data:t sgml-parent-document:nil sgml-default-dtd-file:"../reference.ced" sgml-exposed-tags:nil sgml-local-catalogs:"/usr/lib/sgml/catalog" sgml-local-ecat-files:nil End: -->