 |
|
Name
DROP LANGUAGE -- remove a user-defined procedural language
Synopsis
DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]
Inputs
- 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 in the language). - RESTRICT
Refuse to drop the language if there are any dependent objects.
This is the default.
Outputs
- DROP LANGUAGE
This message is returned if the language is successfully dropped. - ERROR: Language " name" doesn't exist
This message occurs if a language called
name is
not found in the database.
Description
DROP PROCEDURAL LANGUAGE will remove the definition
of the previously registered procedural language called
name.
Notes
The DROP PROCEDURAL LANGUAGE statement is
a PostgreSQL language extension.
Refer to
CREATE LANGUAGE
for information on how to create procedural languages.
Usage
This command removes the PL/Sample language:
DROP LANGUAGE plsample;
Compatibility
SQL92
There is no DROP PROCEDURAL LANGUAGE in
SQL92.
This file was copied from PostgreSQL 7.3.1 help system.
|
