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.