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

# drop\_cast(7)

remove a cast

## NAME

DROP CAST - remove a cast

## SYNOPSIS

```
DROP CAST (sourcetype AS targettype) [ CASCADE | RESTRICT ]

```

## DESCRIPTION

**DROP CAST** removes a previously defined cast.

To be able to drop a cast, you must own the source or the target data type. These are the same privileges that are required to create a cast.

## PARAMETERS

- *sourcetype*

  The name of the source data type of the cast.

- *targettype*

  The name of the target data type of the cast.

- **CASCADE**

  - **RESTRICT**

  These key words do not have any effect, since there are no dependencies on casts.

## EXAMPLES

To drop the cast from type **text** to type **int**:

```
DROP CAST (text AS int);

```

## COMPATIBILITY

The **DROP CAST** command conforms to the SQL standard.

## SEE ALSO

CREATE CAST \[[**create\_cast**(7)](/create_cast/7.md)\]