DROP LANGUAGE
Removes a procedural language.
Synopsis
DROP [PROCEDURAL] LANGUAGE [IF EXISTS] <name> [CASCADE | RESTRICT]Description
DROP LANGUAGE removes the definition of the previously registered procedural language.
You must be a superuser or the owner of the language to drop it.
Parameters
| Parameter | Description |
|---|---|
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.