Creates a user-defined ARRAY or VARRAY data type that is constructed from a predefined Teradata data type, a distinct UDT data type, a structured UDT data type, or an internal UDT data type.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Unlike the ANSI SQL:2011 requirement, you must create a one-dimensional ARRAY or VARRAY type before you can use it. This variance from the ANSI SQL:2011 standard is compatible with Oracle one-dimensional VARRAY types and with IBM SQL PL one-dimensional ARRAY types.
ANSI SQL:2011 does not define a standard for multidimensional ARRAY types, nor do other major relational database management system vendors support them.
One-Dimensional ARRAY - Teradata Form
One-dimensional ARRAY types only support a lower bound of 1. Every one-dimensional ARRAY type you create has a first array element indexed by the number 1.
One-Dimensional VARRAY - Oracle-Compatible Form
One-dimensional VARRAY types only support a lower bound of 1. Every one-dimensional VARRAY type you create has a first array element indexed by the number 1.
Required Privileges
You must have either the UDTTYPE or UDTMETHOD privilege on the SYSUDTLIB database to create an ARRAY or VARRAY UDT.
Privileges Granted Automatically
None.