17.10 - method_clause - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
The method to be altered.
INSTANCE
that the method named as method_name is an instance method.
This is the default.
CONSTRUCTOR
The method named as method_name is a constructor method.
SYSUDTLIB.method_name
The name (not the specific method name) for the method to be altered.
There must already be a method associated with the specified UDT name that has the same signature.
The specification of SYSUDTLIB is optional.
data_type
An optional data type specification for the parameters passed to method_name.
If you do not specify a data type list, then the specified method must be the only one with that name in the SYSUDTLIB database.