16.20 - Adding Methods To a UDT - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
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.