User-Defined Data Types - Teradata Vantage - Analytics Database

Database Design

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Publication Date
June 2022
Content Type
Administration
User Guide
Publication ID
B035-1094-172K
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ogg1628096130566.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
ft:sourceId
dita
dita:id
zqc1472244571611
lifecycle
lifecycle
Product Category
Teradata Vantage™

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 for information about how to determine the storage size of a given UDT column.