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

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Release Date
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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