DROP LANGUAGE

Function

DROP LANGUAGE deletes a procedural language. A single-node system or centralized system does not support deleting procedural languages.

DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]

IF EXISTS
Sends a notice instead of an error if a specified procedural language does not exist.
name
Specifies the name of an existing language. For downward compatibility, the name can be enclosed in single quotation marks (').
CASCADE
Automatically deletes objects that depend on the language (for example, functions written in the language).
RESTRICT
Refuses to delete the object if any objects depend on it. This is a default parameter.

Run the following command to delete the plsample language:

DROP LANGUAGE plsample;

The SQL standard does not contain the DROP LANGUAGE statement.