16.20 - Internal And External Representations Of Distinct 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)

The internal and external representations of distinct UDTs are indicated in the following table:

FOR this type of representation … A distinct UDT is stored in the following format:
internal the same as its underlying predefined data type.
client the same as its underlying predefined data type.

This is handled by the system-generated transform for the UDT that is created when the distinct UDT is created.

See the appropriate Teradata Tools and Utilities documentation for details of how a particular client application deals with distinct UDTs.