Performs any of the following operations for a UDT.
- Add a new attribute to a structured UDT definition.
- Drop an existing attribute from a structured UDT definition.
- Add a method to a distinct or structured UDT definition.
- Drop a method from a distinct or structured UDT definition.
- Recompile the source code for a distinct, structured, ARRAY, or VARRAY type definition.
ANSI Compliance
ALTER TYPE is ANSI SQL-2011-compliant with Teradata extensions.
Other SQL dialects support similar non-ANSI standard statements with names such as DROP METHOD.
Required Privileges
To add or drop an attribute, you must have the UDTTYPE or UDTMETHOD privilege on the SYSUDTLIB database.
To add or drop a method, you must have the UDTMETHOD privilege on the SYSUDTLIB database.
Privileges Granted Automatically
None.