DROP LANGUAGE ​

Function ​

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

Syntax ​

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

Parameter Description ​

• 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.

Examples ​

Run the following command to delete the plsample language:

DROP LANGUAGE plsample;

Compatibility ​

The SQL standard does not contain the DROP LANGUAGE statement.