15.10 - Example: HELP TYPE with No Options for a One-Dimensional Array - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

Suppose you create either of the following equivalent one-dimensional ARRAY/VARRAY types, the first using Teradata format and the second using Oracle-compatible format.

     CREATE TYPE phonenumbers_ary AS 
     CHARACTER(10) ARRAY[5];
     CREATE TYPE phonenumbers_ary AS 

A HELP TYPE request for phonenumbers_ary returns the following information.

     HELP TYPE phonenumbers_ary;
      *** Help information returned. 19 rows.
      *** Total elapsed time was 1 second.
Name phonenumbers_ary
      Internal Type A1
      External Type CV
         Max Length                121
        Array (Y/N) Y
         Dimensions                  1
       Element Type CF
           UDT Name ?
        Array Scope [1:5]
       Total Digits     ?
  Fractional Digits    ?
       Contains LOB N
           Ordering F
  Ordering Category M
   Ordering Routine LOCAL
               Cast N
          Transform Y
             Method Y
          Char Type  ?