16.20 - Internal And External Representations Of Structured UDTs - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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:
internal A concatenation of the data types of its individual attributes.
client however, it is defined by its fromsql transform functionality.

See CREATE TRANSFORM and REPLACE TRANSFORM 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.