DROP CONVERSION

DROP CONVERSION

Name

DROP CONVERSION -- remove a user-defined conversion

Synopsis

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

CREATE CONVERSION

Home
Online Resources
General
Beginner Tutorials
MySQL
PostgreSQL
Oracle
mSQL
Microsoft SQL
Contact Us
Random quote of the moment:
Political speeches are like steer horns. A point here, a point there, and a lot of bull inbetween. -- Alfred E. Neuman
 
http://www.sql.org/
 
Proudly designed and hosted by OmegaSphere, providers of all your Web Hosting, SSL Certificate, and Domain Name needs!