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.