17.10 - column_data_type_attribute - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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 Vantage, 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.