15.00 - Adding Methods To a UDT - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Adding Methods To a UDT

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” on page 403).

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 type method.


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.