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