Teradata allows you to create 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.
- 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
.
An Array User Defined Type property form opens in the Details view.
- Click the General 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 Commit.
- Click OK. The property form shows the properties of the new UDT.