15.10 - DROP SPECIFIC METHOD SYSUDTLIB.specific_method_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Drop the specific method named specific_method_name from the definition of the UDT named in the FOR UDT_name clause.

The specification of SYSUDTLIB is optional.

When you drop a method definition, the system also deletes all files associated with that method.

You cannot specify this option for an ARRAY or VARRAY type.

To replace the external routine for a method, use the REPLACE METHOD statement (see REPLACE METHOD).

data_type
The data type of the attribute to be dropped.
UDT_name
User-defined type to be dropped.
FOR UDT_name
The name of the UDT from which the association with the specified set of method signatures is to be dropped.
You cannot specify this option for an ARRAY or VARRAY type.