Adding to and Dropping Methods From a UDT | ALTER TYPE | Teradata Vantage - 17.10 - Adding Methods To a UDT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

This clause adds a method signature to the specified UDT. You cannot invoke the new method until its body is specified completely with an appropriate CREATE METHOD request (see CREATE METHOD).

A new method cannot be a duplicate of any existing methods associated with the specified UDT.

IF the UDT is this type … THEN the new method associated with it must be specified as a …
distinct distinct type method.
structured structured type method.

The ability to add multiple methods using the ADD METHOD option is a Teradata extension to the ANSI SQL:2011 standard. You have the option of either submitting ALTER TYPE requests that comply with the ANSI SQL standard by adding only one method at a time, or of adding multiple methods simultaneously using the Teradata extension to the ANSI SQL:2011 syntax.