Removes a cast.
DROP CAST [IF EXISTS] (<sourcetype> AS <targettype>) [CASCADE | RESTRICT]
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.
To drop the cast from type text
to type int
:
DROP CAST (text AS int);
There DROP CAST
command conforms to the SQL standard.
Parent topic: SQL Commands