DROP CAST in Teradata

In order to drop a cast definition from the dictionary, DROP CAST can be used.

Syntax:
DROP CAST (source_data_type AS target_data_type);

You must have either the UDTTYPE or the UDTMETHOD privilege on the SYSUDTLIB database to drop a user-defined cast for a UDT.

Example:
The following example drops the cast of UDT square to UDT rectangle.
DROP CAST (square AS rectangle);