column_data_type_attribute - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
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.