Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
DROP CONVERSION
Prev UpSQL CommandsHome Next

DROP CONVERSION

DROP CONVERSION — remove a conversion

Synopsis

DROP CONVERSION [ IF EXISTS ]name [ CASCADE | RESTRICT ]

Description#

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

Parameters

IF EXISTS

Do not throw an error if the conversion does not exist. A notice is issued in this case.

name

The name of the conversion. The conversion name can 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 namedmyname:

DROP CONVERSION myname;

Compatibility#

There is noDROP CONVERSION statement in the SQL standard, but aDROP TRANSLATION statement that goes along with theCREATE TRANSLATION statement that is similar to theCREATE CONVERSION statement in Postgres Pro.


Prev Up Next
DROP COLLATION Home DROP DATABASE
pdfepub
Go to Postgres Pro Standard 17
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp