---
name: "drop_conversion"
section: "7"
platform: "linux"
package: "postgresql"
version: "7.4.7-6sarge6"
release: "Debian 3.1 (Sarge)"
platforms: ["linux"]
url: "https://new.carta.tech/drop_conversion"
---

# drop\_conversion(7)

remove a conversion

## NAME

DROP CONVERSION - remove a conversion

## SYNOPSIS

```
DROP 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

- *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.

## EXAMPLES

To drop the conversion named myname:

```
DROP CONVERSION myname;

```

## COMPATIBILITY

There is no **DROP CONVERSION** statement in the SQL standard.

## SEE ALSO

ALTER CONVERSION \[[**alter\_conversion**(7)](/alter_conversion/7.md)\], CREATE CONVERSION \[**create\_conversion**(l)\]