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
DROP CAST (text AS int);
DROP CAST command conforms to the SQL standard.
Parent topic: SQL Command Reference