If a data type or its parent data type to be deleted satisfies any of the conditions listed below, WITH PROGRAM must be specified in DROP DATA TYPE; otherwise, the deletion processing will fail:

• The data type is specified in an SQL parameter in a procedure or function.
• The data type is specified for a function's return value.
• The data type is specified in an argument or return value of a function that is called from a procedure or another function.
• The data type is specified in a procedure, function, or trigger (if an abstract data type is being accessed by a component specification, this includes all data types used to build the abstract data type).

Deleting an abstract data type invalidates any stored routine or trigger that satisfies the above conditions. If this happens, use the ALTER PROCEDURE, ALTER ROUTINE, or ALTER TRIGGER statement to re-create the stored routines and stored triggers.

• A data type cannot be deleted if its parent data type is used in a table definition.
• A data type also cannot be deleted if the data type itself or its parent data type is used in another abstract data type.