16.20 - Column Data Type Attributes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

For information about converting data between data types, see Teradata Vantage™ Data Types and Literals, B035-1143.

The following column attributes are supported for UDT, Geospatial, and Period columns:
  • DEFAULT NULL
  • FORMAT
  • NAMED
  • NOT NULL
  • NULL
  • TITLE
The following column attributes are not supported for UDT, Geospatial, and Period columns:
  • CASESPECIFIC or CS
  • NOT CASESPECIFIC or NOT CS
  • CHARACTER SET
  • COMPRESS
  • DEFAULT DATE
  • DEFAULT TIME
  • DEFAULT USER
  • UPPERCASE or UC

For a complete list of the attributes that are supported for Teradata Database, see Teradata Vantage™ Data Types and Literals, B035-1143.

For information about the additional column attributes that apply to the columns of temporal tables, see Teradata Vantage™ Temporal Table Support , B035-1182 and Teradata Vantage™ ANSI Temporal Table Support , B035-1186 .