15.00 - CREATE TYPE (Structured Form) - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
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:

internal

A concatenation of the data types of its individual attributes.

client

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.