17.10 - Internal And External Representations Of Distinct UDTs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
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.