A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 5.x documentation.
Removes a conversion.
DROP CONVERSION [IF EXISTS] name [CASCADE | RESTRICT]
DROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you must own the conversion.
- IF EXISTS
- Do not throw an error if the conversion does not exist. A notice is issued in this case.
- The name of the conversion. The conversion name may be schema-qualified.
- These keywords have no effect since there are no dependencies on conversions.
Drop the conversion named myname:
DROP CONVERSION myname;
There is no DROP CONVERSION statement in the SQL standard.