Use the following procedure to drop an existing UDT.
1 From the main window, click Tools > Administer UDTs.
2 Select the role in the Type Name field.
3 Click Drop.
A confirmation message appears. Teradata Administrator checks to ensure this Type is not used in a table, procedure, or other objects.
4 Click Yes.
If the drop is successful, the UDT is deleted from the cache.
If the drop fails, messages appear at the top of the DDL showing which objects were dropped and the error that occurred for the last object that failed to drop.
5 Click Usage to list the remaining objects to be dropped. A list displays of tables, views, and macros that use this Type, and UDFs that implement it.