17.00 - Example: Three-Dimensional ARRAY Type Using Different Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

These examples create the same 3-dimensional ARRAY type as Example: Three-Dimensional ARRAY Type, but use different syntax variations to define them.

The first example uses Teradata-style syntax to define a variant of the seismic_cube type, seismic_cube_2, based on the type measures_udt, which is defined in Example: Three-Dimensional ARRAY Type.

     CREATE TYPE seismic_cube_2 AS 
     measures_udt ARRAY [5][7][20];

The next example uses another variant of Teradata-style syntax to define an equivalent seismic_cube type named seismic_cube_3.

     CREATE TYPE seismic_cube_3 AS 
     measures_udt ARRAY [1:5][7][1:20];