CREATE TYPE Syntax | Teradata Vantage - CREATE TYPE Syntax (ARRAY/VARRAY Form) - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

One-Dimensional ARRAY - Teradata Form

CREATE TYPE [SYSUDTLIB.] array_type_name
  AS data_type ARRAY [ number_of_elements ]
  [ DEFAULT NULL ] [;]

One-Dimensional VARRAY - Oracle-Compatible Form

CREATE TYPE [SYSUDTLIB.] array_type_name
  AS { VARYING ARRAY | VARRAY } ( number_of_elements ) OF data_type
  [ DEFAULT NULL ] [;]

Multidimensional Array - Teradata Form

CREATE TYPE [SYSUDTLIB.] array_type_name
  AS data_type ARRAY [ { lower_bound : upper_bound | maximum_size } ]
  [ DEFAULT NULL ] [;]

Multidimensional Array - Oracle-Compatible Form

CREATE TYPE [SYSUDTLIB.] array_type_name
  AS { VARYING ARRAY | VARRAY } ( { lower_bound : upper_bound | maximum_size } )
    OF data_type [ DEFAULT NULL ] [;]

Array Data Types

data_type
{ INTEGER | SMALLINT | BIGINT | BYTEINT | DATE |

  [ TIME | TIMESTAMP ] [(fractional_seconds_precision)] [WITH TIME ZONE] |

  INTERVAL YEAR [(precision)] [TO MONTH] |

  INTERVAL MONTH [(precision)] |

  INTERVAL DAY [(precision)]
    [TO { HOUR | MINUTE | SECOND [(fractional_seconds_precision)] }] } |
 

  INTERVAL HOUR [(precision)]
    [TO { MINUTE | SECOND [(fractional_seconds_precision)] }] |

  INTERVAL MINUTE [(precision)] [TO SECOND [(fractional_seconds_precision)]] |

  INTERVAL SECOND [ ( precision [, fractional_seconds_precision ] ) |

  PERIOD (DATE) |

  PERIOD ({ TIME | TIMESTAMP }) [(precision)] [WITH TIME ZONE] |

  REAL |

  DOUBLE PRECISION |

  FLOAT [(integer)] |

  NUMBER [({ integer | *} [, integer]... )] |

  { DECIMAL | NUMERIC } [(integer [, integer]...)] |

  { CHAR | BYTE | GRAPHIC } [(integer)] |

  { VARCHAR | CHAR VARYING | VARBYTE | VARGRAPHIC } [(integer)] |

  LONG VARCHAR |

  LONG VARGRAPHIC
}