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.