16.20 - RENAME FUNCTION (External Form) and UDTs - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

You cannot directly change the name of a UDF that performs the role of a transform, ordering, or cast for a UDT.

You must first drop the corresponding transform, ordering, or cast definitions. Then, rename the UDT. To drop an ordering or a transform, see DROP ORDERING or DROP TRANSFORM. To drop a cast, see “DROP CAST” in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.