NAME

DROP LANGUAGE - 刪除一個(gè)過程語言

SYNOPSIS

DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]

DESCRIPTION 描述

DROP LANGUAGE 將刪除曾注冊(cè)過的過程語言 name。  

PARAMETERS 參數(shù)

name

 現(xiàn)存語言的名稱。出于向下兼容的考慮，這個(gè)名字可以用單引號(hào)包圍。

CASCADE

 自動(dòng)刪除依賴于改語言的對(duì)象（比如該語言寫的函數(shù)）。

RESTRICT

 如果存在依賴對(duì)象，則拒絕刪除。這個(gè)是缺省。

EXAMPLES 例子

 下面命令刪除 plsample 語言：

DROP LANGUAGE plsample;

COMPATIBILITY 兼容性

 在 SQL 標(biāo)準(zhǔn)里沒有 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)