Teradata allows you to create user-defined data types (UDTs) to extend your SQL functionality.
A distinct UDT is mapped to a single predefined Teradata data type.For example, a Euro UDT might be based on the predefined data type DECIMAL, but it would stand alone as a distinct data type.
- 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.
-
In the Object List Viewer toolbar, click .
A Distinct User Defined Type property form opens in the Details view.
- Click the General category and enter values for the new UDT.
- Click the Options category and enter values for the new UDT.
- [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new UDT.
- Click OK. The property form shows the properties of the new UDT.