17.10 - UDT Data Type - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

This section describes the user-defined type (UDT) data type.

For information about the VARIANT_TYPE UDT, see VARIANT_TYPE Data Type.

The UDT data type represents a custom data type for modeling the structure and behavior of real-world entities used by applications.

ANSI Compliance

UDTs are ANSI SQL:2011 compliant.

Required Privileges

To create a table that has a UDT column, you must have the UDTUSAGE, UDTTYPE, or UDTMETHOD privilege on the SYSUDTLIB database, or have the UDTUSAGE privilege on the specified UDT.

To perform a query on a UDT column, you must have the UDTUSAGE privilege on the specified UDT.