ALTER TYPE SQL Statement | Teradata Vantage - ALTER TYPE - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™
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.