15.10 - CREATE TYPE (ARRAY/VARRAY Form) - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Purpose

Creates a user-defined ARRAY or VARRAY data type that is constructed from a predefined Teradata Database data type, a distinct UDT data type, a structured UDT data type, or an internal UDT data type.

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.

None.

Syntax - One-Dimensional ARRAY - Teradata Form



Syntax - One-Dimensional VARRAY - Oracle-Compatible Form



Syntax - Multidimensional Array - Teradata Form



Syntax - Multidimensional Array - Oracle-Compatible Form



Syntax - Array Data Types