15.00 - CREATE TYPE (Structured 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 (Structured Form)

Internal And External Representations Of Structured UDTs

The internal and external representations of structured UDTs are indicated in the following table:


FOR this type of representation …

A structured UDT is stored in the following format:


A concatenation of the data types of its individual attributes.


however it is defined by its fromsql transform functionality.

See “CREATE TRANSFORM/ REPLACE TRANSFORM” on page 694 for details.

Client software does not see UDT values, but values having a predefined data type representing a UDT on the Teradata platform. How a platform UDT is transformed to a client predefined type is entirely at the discretion of the transform developer.

See the appropriate Teradata Tools and Utilities documentation for details of how a particular client application deals with structured UDTs.