DROP CONVERSION

Removes 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 may be schema-qualified.

<targettype>
The name of the target data type of the cast to be removed.

CASCADE
RESTRICT
These keywords have no effect since there are no dependencies on conversions.

Examples

Drop the conversion named myname:

DROP CONVERSION myname;

Compatibility

There is no DROP CONVERSION statement in the SQL standard.

See Also

CREATE CONVERSION, ALTER CONVERSION