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.