# info > DROP_TRANSFORM

---
type: CommandReference
command: DROP TRANSFORM
mode: man
section: 7
source: man-pages
---

## Quick Reference

- `DROP TRANSFORM FOR type_name LANGUAGE lang_name` — Remove a transform.
- `DROP TRANSFORM IF EXISTS FOR type_name LANGUAGE lang_name` — Remove a transform if it exists, without error.

## Name

DROP TRANSFORM - remove a transform

## Synopsis

DROP TRANSFORM [ IF EXISTS ] FOR type_name LANGUAGE lang_name [ CASCADE | RESTRICT ]
To drop a transform, you must own the type and the language (same privileges required to create a transform).

## Options

- `IF EXISTS` — Do not throw an error if the transform does not exist. A notice is issued in this case.
- `type_name` — The name of the data type of the transform.
- `lang_name` — The name of the language of the transform.
- `CASCADE` — Automatically drop objects that depend on the transform, and in turn all objects that depend on those objects.
- `RESTRICT` — Refuse to drop the transform if any objects depend on it. This is the default.

## Examples

shell
DROP TRANSFORM FOR hstore LANGUAGE plpythonu;
## See Also

CREATE TRANSFORM ([CREATE_TRANSFORM(7)](https://www.chedong.com/phpMan.php/man/CREATETRANSFORM/7/markdown))