DROP TRANSFORM in Teradata

You must have either the UDTTYPE privilege or the UDTMETHOD privilege on the SYSUDTLIB database to be able to drop a transform group.

Example:
The following example drops the transform group named C_routine from the UDT named address with the restriction that no table in the entire system can be using address as the data type for any of its columns:

DROP TRANSFORM C_routine FOR SYSUDTLIB.address;