15.00 - CREATE TYPE (Distinct Form) - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

CREATE TYPE (Distinct Form)

Internal And External Representations Of Distinct UDTs

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:


the same as its underlying predefined data type.


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.