1DROP LANGUAGE(7)                 SQL Commands                 DROP LANGUAGE(7)
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 removes the definition of a previously registered proce‐
15       dural language. You must be a superuser or the owner of the language to
16       use DROP LANGUAGE.
17

PARAMETERS

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

EXAMPLES

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

COMPATIBILITY

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

SEE ALSO

44       ALTER   LANGUAGE   [alter_language(7)],  CREATE  LANGUAGE  [create_lan‐
45       guage(7)], droplang(1)
46
47
48
49SQL - Language Statements         2011-09-22                  DROP LANGUAGE(7)