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

   1 <!-- doc/src/sgml/ref/drop_collation.sgml -->
   2
   3 <refentry id="SQL-DROPCOLLATION">
   4  <refmeta>
   5   <refentrytitle>DROP COLLATION</refentrytitle>
   6   <manvolnum>7</manvolnum>
   7   <refmiscinfo>SQL - Language Statements</refmiscinfo>
   8  </refmeta>
   9
  10  <refnamediv>
  11   <refname>DROP COLLATION</refname>
  12   <refpurpose>remove a collation</refpurpose>
  13  </refnamediv>
  14
  15  <indexterm zone="sql-dropcollation">
  16   <primary>DROP COLLATION</primary>
  17  </indexterm>
  18
  19  <refsynopsisdiv>
  20 <synopsis>
  21 DROP COLLATION [ IF EXISTS ] <replaceable>name</replaceable> [ CASCADE | RESTRICT ]
  22 </synopsis>
  23  </refsynopsisdiv>
  24
  25  <refsect1 id="sql-dropcollation-description">
  26   <title>Description</title>
  27
  28   <para>
  29    <command>DROP COLLATION</command> removes a previously defined collation.
  30    To be able to drop a collation, you must own the collation.
  31   </para>
  32  </refsect1>
  33
  34  <refsect1>
  35   <title>Parameters</title>
  36
  37    <variablelist>
  38     <varlistentry>
  39      <term><literal>IF EXISTS</literal></term>
  40      <listitem>
  41       <para>
  42        Do not throw an error if the collation does not exist.
  43        A notice is issued in this case.
  44       </para>
  45      </listitem>
  46     </varlistentry>
  47
  48     <varlistentry>
  49      <term><replaceable>name</replaceable></term>
  50
  51      <listitem>
  52       <para>
  53        The name of the collation. The collation name can be
  54        schema-qualified.
  55       </para>
  56      </listitem>
  57     </varlistentry>
  58
  59     <varlistentry>
  60      <term><literal>CASCADE</literal></term>
  61      <listitem>
  62       <para>
  63        Automatically drop objects that depend on the collation.
  64       </para>
  65      </listitem>
  66     </varlistentry>
  67
  68     <varlistentry>
  69      <term><literal>RESTRICT</literal></term>
  70      <listitem>
  71       <para>
  72        Refuse to drop the collation if any objects depend on it.  This
  73        is the default.
  74       </para>
  75      </listitem>
  76     </varlistentry>
  77    </variablelist>
  78  </refsect1>
  79
  80  <refsect1 id="sql-dropcollation-examples">
  81   <title>Examples</title>
  82
  83   <para>
  84    To drop the collation named <literal>german</>:
  85 <programlisting>
  86 DROP COLLATION german;
  87 </programlisting></para>
  88  </refsect1>
  89
  90  <refsect1 id="sql-dropcollation-compat">
  91   <title>Compatibility</title>
  92
  93   <para>
  94    The <command>DROP COLLATION</command> command conforms to the
  95    <acronym>SQL</acronym> standard, apart from the <literal>IF
  96    EXISTS</> option, which is a <productname>PostgreSQL</> extension.
  97   </para>
  98  </refsect1>
  99
 100  <refsect1>
 101   <title>See Also</title>
 102
 103   <simplelist type="inline">
 104    <member><xref linkend="sql-altercollation"></member>
 105    <member><xref linkend="sql-createcollation"></member>
 106   </simplelist>
 107  </refsect1>
 108
 109 </refentry>