---
title: "DROP CONVERSION"
id: sql-dropconversion
pg_version: "20devel"
---

<a id="sql-dropconversion"></a>

# DROP CONVERSION — remove a conversion

## Synopsis

```
DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
```

<a id="sql-dropconversion-description"></a>

## Description

`DROP CONVERSION` removes a previously defined conversion. To be able to drop a conversion, you must own the conversion. 

<a id="id-1.9.3.109.6"></a>

## 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 can be schema-qualified. **`CASCADE`**, **`RESTRICT`**

 These key words do not have any effect, since there are no dependencies on conversions. <a id="sql-dropconversion-examples"></a>

## Examples

To drop the conversion named `myname`: 
DROP CONVERSION myname;


<a id="sql-dropconversion-compat"></a>

## Compatibility

There is no `DROP CONVERSION` statement in the SQL standard, but a `DROP TRANSLATION` statement that goes along with the `CREATE TRANSLATION` statement that is similar to the `CREATE CONVERSION` statement in PostgreSQL. 

<a id="id-1.9.3.109.9"></a>

## See Also

[ALTER CONVERSION](sql-alterconversion.md), [CREATE CONVERSION](sql-createconversion.md)