15.00 - Table Kinds and UDT, Period, and Geospatial Data Types - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Table Kinds and UDT, Period, and Geospatial Data Types

The following table kind specifications all support UDT, ARRAY, VARRAY, Geospatial, and Period columns. Geospatial and Period data types are implemented internally as UDTs.

  • SET
  • MULTISET
  • GLOBAL TEMPORARY
  • VOLATILE
  • Global temporary trace tables do not support UDT columns. See “CREATE GLOBAL TEMPORARY TRACE TABLE” on page 317.

    Related Topics

    See “CREATE TABLE” in SQL Data Definition Language Syntax and Examples for information about the syntax used to specify table kinds.

    You cannot use ALTER TABLE requests to change the table kind of a table.