Example: Adding Multiple Attributes to a Structured UDT - Analytics Database - Teradata Vantage

The following example adds three attributes named country, continent, and zone to the structured UDT named address:

ALTER TYPE address      /* Add 3 attributes to structured type */
 ADD ATTRIBUTE country   VARCHAR(15), 
               continent VARCHAR(20), 
               zone      INTEGER;