NAME
DROP LANGUAGE - 删除一个过程语言
SYNOPSIS
DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]
DESCRIPTION 描述
DROP LANGUAGE 将删除曾注册过的过程语言 name。
PARAMETERS 参数
- name
现存语言的名称。出于向下兼容的考虑，这个名字可以用单引号包围。- CASCADE
自动删除依赖于改语言的对象（比如该语言写的函数）。- RESTRICT
如果存在依赖对象，则拒绝删除。这个是缺省。
EXAMPLES 例子
下面命令删除 plsample 语言：
DROP LANGUAGE plsample;
COMPATIBILITY 兼容性
在 SQL 标准里没有 DROP PROCEDURAL LANGUAGE。
SEE ALSO 参见
ALTER LANGUAGE [alter_language(7)], CREATE LANGUAGE [create_language(l)], droplang(1)
#p#
NAME
DROP LANGUAGE - remove a procedural language
SYNOPSIS
DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]
DESCRIPTION
DROP LANGUAGE will remove the definition of the previously registered procedural language called name.
PARAMETERS
- 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 any objects depend on it. This is the default.
EXAMPLES
This command removes the procedural language plsample:
DROP LANGUAGE plsample;
COMPATIBILITY
There is no DROP LANGUAGE statement in the SQL standard.
SEE ALSO
ALTER LANGUAGE [alter_language(7)], CREATE LANGUAGE [create_language(l)], droplang(1)
