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)