---
name: "DROP_CAST"
section: "7"
platform: "linux"
package: "postgresql"
version: "18.6-4"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/DROP_CAST"
---

# DROP\_CAST(7)

remove a cast

## NAME

DROP\_CAST - remove a cast

## SYNOPSIS

```
DROP CAST [ IF EXISTS ] (source_type AS target_type) [ 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

IF EXISTS

Do not throw an error if the cast does not exist. A notice is issued in this case.

*source\_type*

The name of the source data type of the cast.

*target\_type*

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))