DROP SPECIFIC METHOD SYSUDTLIB.specific_method_name - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

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.