DROP LANGUAGE
Removes a procedural language.
Synopsis
DROP [PROCEDURAL] LANGUAGE [IF EXISTS] <name> [CASCADE | RESTRICT]
Description
DROP LANGUAGE
will remove the definition of the previously registered procedural language. You must be a superuser or owner of the language to drop a language.
Parameters
-
PROCEDURAL
-
Optional keyword - has no effect.
-
IF EXISTS
-
Do not throw an error if the language does not exist. A notice is issued in this case.
-
name
-
The name of an existing procedural language. For backward compatibility, the name may be enclosed by single quotes.
-
CASCADE
-
Automatically drop objects that depend on the language (such as functions written in that language).
-
RESTRICT
-
Refuse to drop the language if any objects depend on it. This is the default.
Examples
Remove the procedural language plsample
:
DROP LANGUAGE plsample;
Compatibility
There is no DROP LANGUAGE
statement in the SQL standard.
See Also
ALTER LANGUAGE, CREATE LANGUAGE
Parent topic: SQL Command Reference