15.00 - Altering Attributes Of A Structured UDT Definition - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Altering Attributes Of A Structured UDT Definition

If you attempt to add or drop an attribute from the specified structured UDT, the system aborts the request if any other database object references that UDT.

This action protects the integrity of the database from corruption caused by objects depending on the previous definition of a structured UDT that is no longer correct.

You, as a UDT developer, are responsible for performing all the necessary clean up on all of the following database objects before you drop any attributes from a structured UDT.

  • Casts associated with the UDT.
  • See “CREATE CAST/ REPLACE CAST” on page 212.

  • Orderings for the UDT.
  • See “CREATE ORDERING/ REPLACE ORDERING” on page 416.

  • Transforms for the UDT.
  • See “CREATE TRANSFORM/ REPLACE TRANSFORM” on page 694.

  • Tables whose columns are typed with the UDT.
  • See “CREATE TABLE” on page 508.

  • Structured UDTs that use the UDT.
  • See “CREATE TYPE (Structured Form)” on page 758.

  • UDFs and methods that use the UDT as a parameter type.
  • See “CREATE FUNCTION (External Form)/ REPLACE FUNCTION (External Form)” on page 240 and “CREATE METHOD” on page 403.