NAME

DROP CONVERSION - 刪除一個(gè)用戶定義的編碼轉(zhuǎn)換

SYNOPSIS

DROP CONVERSION name [ CASCADE | RESTRICT ]

DESCRIPTION 描述

DROP CONVERSION 刪除一個(gè)以前定義的編碼轉(zhuǎn)換。 要想刪除一個(gè)轉(zhuǎn)換，你必須擁有該轉(zhuǎn)換。  

PARAMETERS 參數(shù)

name

 編碼轉(zhuǎn)換的名字。這個(gè)名字可以用模式修飾。

CASCADE

RESTRICT

 這些鍵字沒有作用，因?yàn)榫幋a轉(zhuǎn)換上沒有依賴關(guān)系。

EXAMPLES 例子

 刪除一個(gè)叫做 myname 的編碼轉(zhuǎn)換：

DROP CONVERSION myname;

COMPATIBILITY 兼容性

 SQL 標(biāo)準(zhǔn)里沒有 DROP CONVERSION。  

SEE ALSO 參見

ALTER CONVERSION [alter_conversion(7)], CREATE CONVERSION [create_conversion(l)]

#p#

NAME

DROP CONVERSION - remove a conversion

SYNOPSIS

DROP CONVERSION name [ CASCADE | RESTRICT ]

DESCRIPTION

DROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you must own the conversion.  

PARAMETERS

name

The name of the conversion. The conversion name may be schema-qualified.

CASCADE

RESTRICT

These key words do not have any effect, since there are no dependencies on conversions.

EXAMPLES

To drop the conversion named myname:

DROP CONVERSION myname;

COMPATIBILITY

There is no DROP CONVERSION statement in the SQL standard.  

SEE ALSO

ALTER CONVERSION [alter_conversion(7)], CREATE CONVERSION [create_conversion(l)]