---
title: "DROP CAST"
url: "https://docs.yugabyte.com/stable/api/ysql/the-sql-language/statements/ddl_drop_cast/"
---

# DROP CAST

Use the DROP CAST statement to remove a cast.

## Synopsis

Use the DROP CAST statement to remove a cast.

## Syntax

- [![Grammar Icon](/icons/file-lines.svg)Grammar](#grammar-1)
- [![Diagram Icon](/icons/diagram.svg)Diagram](#diagram-1)

```output.ebnf
drop_cast ::= DROP CAST [ IF EXISTS ] ( cast_signature ) 
              [ CASCADE | RESTRICT ]
```

#### drop\_cast

DROPCASTIFEXISTS([cast\_signature](/stable/api/ysql/syntax_resources/grammar_diagrams#cast-signature))CASCADERESTRICT

## Semantics

See the semantics of each option in the [PostgreSQL docs](https://www.postgresql.org/docs/15/sql-dropcast.html "PostgreSQL docs").

## Examples

Basic example.

```plpgsql
yugabyte=# CREATE FUNCTION sql_to_date(integer) RETURNS date AS $$
             SELECT $1::text::date
             $$ LANGUAGE SQL IMMUTABLE STRICT;
yugabyte=# CREATE CAST (integer AS date) WITH FUNCTION sql_to_date(integer) AS ASSIGNMENT;
yugabyte=# DROP CAST (integer AS date);
```

## See also

- [CREATE CAST](/stable/api/ysql/the-sql-language/statements/ddl_create_cast "CREATE CAST")