3
PostgreSQL documentation
6
<refentry id="SQL-DROPLANGUAGE">
8
<refentrytitle id="SQL-DROPLANGUAGE-TITLE">DROP LANGUAGE</refentrytitle>
9
<manvolnum>7</manvolnum>
10
<refmiscinfo>SQL - Language Statements</refmiscinfo>
14
<refname>DROP LANGUAGE</refname>
15
<refpurpose>remove a procedural language</refpurpose>
18
<indexterm zone="sql-droplanguage">
19
<primary>DROP LANGUAGE</primary>
24
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [ CASCADE | RESTRICT ]
29
<title>Description</title>
32
<command>DROP LANGUAGE</command> removes the definition of a
33
previously registered procedural language. You must be a superuser
34
or the owner of the language to use <command>DROP LANGUAGE</>.
39
<title>Parameters</title>
44
<term><literal>IF EXISTS</literal></term>
47
Do not throw an error if the language does not exist. A notice is issued
54
<term><replaceable class="PARAMETER">name</replaceable></term>
57
The name of an existing procedural language. For backward
58
compatibility, the name can be enclosed by single quotes.
64
<term><literal>CASCADE</literal></term>
67
Automatically drop objects that depend on the language (such as
68
functions in the language).
74
<term><literal>RESTRICT</literal></term>
77
Refuse to drop the language if any objects depend on it. This
86
<title>Examples</title>
89
This command removes the procedural language
90
<literal>plsample</literal>:
93
DROP LANGUAGE plsample;
99
<title>Compatibility</title>
102
There is no <command>DROP LANGUAGE</command> statement in the SQL
108
<title>See Also</title>
110
<simplelist type="inline">
111
<member><xref linkend="sql-alterlanguage" endterm="sql-alterlanguage-title"></member>
112
<member><xref linkend="sql-createlanguage" endterm="sql-createlanguage-title"></member>
113
<member><xref linkend="app-droplang"></member>