Creating a Structured UDT - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
sbq1486739977986.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Teradata allows you to create user-defined data types (UDTs) to extend your SQL functionality.

A structured UDT can have one or more attributes that can be based on predefined types or other UDTs. For example, an Address UDT might have street number, street name, city, state and zip code as attributes.

  1. In the Navigator, expand the Databases, right-click the SYSUDTLIB database, and click Show User-Defined Types. A list of the UDTs defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. In the Object List Viewer toolbar, click .

    A Structured User Defined Type property form opens in the Details view.

  3. Click the General category and enter values for the new UDT.
  4. Click the Attributes category and enter values for the new UDT.
  5. Click the Options category and enter values for the new UDT.
  6. [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new UDT.
  7. Click OK. The property form shows the properties of the new UDT.