15.00 - Altering The Method Signatures Of A Structured UDT Definition - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Altering The Method Signatures Of A Structured UDT Definition

If you attempt to add or drop a method signature from the specified UDT, Teradata Database aborts the request if any cast, ordering, or transform set definition in the system references the method (see “CREATE CAST/ REPLACE CAST” on page 212, “CREATE ORDERING/ REPLACE ORDERING” on page 416, and “CREATE TRANSFORM/ REPLACE TRANSFORM” on page 694).

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.