granicus.if.org Git - postgresql/blob - doc/src/sgml/ref/drop_view.sgml

   1 <!--
   2 $PostgreSQL: pgsql/doc/src/sgml/ref/drop_view.sgml,v 1.20 2003/11/29 19:51:38 pgsql Exp $
   3 PostgreSQL documentation
   4 -->
   5
   6 <refentry id="SQL-DROPVIEW">
   7  <refmeta>
   8   <refentrytitle id="SQL-DROPVIEW-TITLE">DROP VIEW</refentrytitle>
   9   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  10  </refmeta>
  11
  12  <refnamediv>
  13   <refname>DROP VIEW</refname>
  14   <refpurpose>remove a view</refpurpose>
  15  </refnamediv>
  16
  17  <indexterm zone="sql-dropview">
  18   <primary>DROP VIEW</primary>
  19  </indexterm>
  20
  21  <refsynopsisdiv>
  22 <synopsis>
  23 DROP VIEW <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | RESTRICT ]
  24 </synopsis>
  25  </refsynopsisdiv>
  26
  27  <refsect1>
  28   <title>Description</title>
  29
  30   <para>
  31    <command>DROP VIEW</command> drops an existing view.  To execute
  32    this command you must be the owner of the view.
  33   </para>
  34  </refsect1>
  35
  36  <refsect1>
  37   <title>Parameters</title>
  38
  39   <variablelist>
  40    <varlistentry>
  41     <term><replaceable class="PARAMETER">name</replaceable></term>
  42     <listitem>
  43      <para>
  44       The name (optionally schema-qualified) of the view to remove.
  45      </para>
  46     </listitem>
  47    </varlistentry>
  48
  49    <varlistentry>
  50     <term><literal>CASCADE</literal></term>
  51     <listitem>
  52      <para>
  53       Automatically drop objects that depend on the view (such as
  54       other views).
  55      </para>
  56     </listitem>
  57    </varlistentry>
  58
  59    <varlistentry>
  60     <term><literal>RESTRICT</literal></term>
  61     <listitem>
  62      <para>
  63       Refuse to drop the view if any objects depend on it.  This is
  64       the default.
  65      </para>
  66     </listitem>
  67    </varlistentry>
  68   </variablelist>
  69  </refsect1>
  70
  71  <refsect1>
  72   <title>Examples</title>
  73
  74   <para>
  75    This command will remove the view called <literal>kinds</literal>:
  76 <programlisting>
  77 DROP VIEW kinds;
  78 </programlisting>
  79   </para>
  80  </refsect1>
  81
  82  <refsect1>
  83   <title>Compatibility</title>
  84
  85   <para>
  86    This command conforms to the SQL standard.
  87   </para>
  88  </refsect1>
  89
  90  <refsect1>
  91   <title>See Also</title>
  92
  93   <simplelist type="inline">
  94    <member><xref linkend="sql-createview" endterm="sql-createview-title"></member>
  95   </simplelist>
  96  </refsect1>
  97
  98 </refentry>
  99
 100 <!-- Keep this comment at the end of the file
 101 Local variables:
 102 mode: sgml
 103 sgml-omittag:nil
 104 sgml-shorttag:t
 105 sgml-minimize-attributes:nil
 106 sgml-always-quote-attributes:t
 107 sgml-indent-step:1
 108 sgml-indent-data:t
 109 sgml-parent-document:nil
 110 sgml-default-dtd-file:"../reference.ced"
 111 sgml-exposed-tags:nil
 112 sgml-local-catalogs:"/usr/lib/sgml/catalog"
 113 sgml-local-ecat-files:nil
 114 End:
 115 -->