1DROP LANGUAGE()                  SQL Commands                  DROP LANGUAGE()
2
3
4

NAME

6       DROP LANGUAGE - remove a procedural language
7
8

SYNOPSIS

10       DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

14       DROP  LANGUAGE  will remove the definition of the previously registered
15       procedural language called name.
16

PARAMETERS

18       IF EXISTS
19              Do not throw an error if the function does not exist.  A  notice
20              is issued in this case.
21
22       name   The  name  of an existing procedural language. For backward com‐
23              patibility, the name may be enclosed by single quotes.
24
25       CASCADE
26              Automatically drop objects that depend on the language (such  as
27              functions in the language).
28
29       RESTRICT
30              Refuse to drop the language if any objects depend on it. This is
31              the default.
32

EXAMPLES

34       This command removes the procedural language plsample:
35
36       DROP LANGUAGE plsample;
37
38

COMPATIBILITY

40       There is no DROP LANGUAGE statement in the SQL standard.
41

SEE ALSO

43       ALTER  LANGUAGE  [alter_language(7)],  CREATE   LANGUAGE   [create_lan‐
44       guage(l)], droplang(1)
45
46
47
48SQL - Language Statements         2008-06-08                   DROP LANGUAGE()