Creating an Array UDT - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use user-defined data types (UDTs) to extend your SQL functionality.

An Array is a type of UDT that can represent up to five dimensions, each with a user-defined maximum number of individual elements. All of the elements of an array must be of the same data type.

  1. In the Navigator, expand Databases, right-click the SYSUDTLIB database, and select Show User-Defined Types.
  2. In the Object List Viewer toolbar, click .
  3. Click the General tab and enter values for the new UDT.
  4. [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to create the new UDT.
  5. Click Commit then OK.