ALTER TYPE SQL Statement | Teradata Vantage - 17.05 - ALTER TYPE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
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.