MogDB
Ecological Tools
Doc Menu

DROP LANGUAGE

Function

DROP LANGUAGE deletes a procedural language.

Syntax

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

Parameter Description

  • IF EXISTS

    Do not throw an error if the specified procedural language does not exist. A notice is issued in this case.

  • name

    Name of an existing language. For downward compatibility, the name can be enclosed in single quotes.

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

Example

Run the following command to delete the plsample language:

DROP LANGUAGE plsample;

Compatibility

The SQL standard does not contain the DROP LANGUAGE statement.