15.00 - CREATE TYPE (Distinct Form) - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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:

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.