15.00 - User-Defined Data Types - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

User‑Defined Data Types

The required byte alignment and storage size of a UDT depends on how it is defined.

 

FOR this category of UDT …

THE byte alignment and storage size are …

Distinct

the same as that of the predefined data type on which it is defined.

Structured

different, depending on whether they are defined on the following type of platform:

  • Packed64 format systems
  • Aligned row format systems
  • See “Sizing Structured UDT Columns” on page 792 for information about how to determine the storage size of a given UDT column.