DROP CAST

DROP CAST

7

SQL - Language Statements

DROP CAST

remove a cast

DROP CAST \[ IF EXISTS \] (

source\_type

AS

target\_type

) \[ CASCADE \| RESTRICT \]

Description {#sql-dropcast-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 {#sql-dropcast-examples}
========

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

    DROP CAST (text AS int);

Compatibility {#sql-dropcast-compat}
=============

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

See Also
========
