column_data_type_attribute - 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™

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 .