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.