DROP CONVERSION
SQL - Language Statements
DROP CONVERSION
remove a user-defined conversion
DROP CONVERSION 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
conversion_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.
Notes
Use CREATE CONVERSION to create user-defined conversions.
The privileges required to drop a conversion may be changed in a future
release.
Examples
To drop the conversion named myname>:
DROP CONVERSION myname;
Compatibility
DROP CONVERSION
is a PostgreSQL extension.
There is no DROP CONVERSION
statement in SQL99.
See Also