Create an Structured UDT | Teradata Studio - Creating a Structured UDT - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
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 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. Click the Attributes tab and enter values for the new UDT.
  5. Click the Options tab and enter values for the new UDT.
  6. Click Open SQL in Editor to see the SQL code that will be executed on the connected system to create the new UDT.
    The property form closes; you will still need to save the UDT after viewing the SQL.
  7. Click "" to save the field information and any SQL changes you made.