DROP CAST
Removes a cast.
Synopsis
DROP CAST [IF EXISTS] (<sourcetype> AS <targettype>) [CASCADE | RESTRICT]
Description
DROP CAST
will delete 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
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.