15.10 - ADD COLUMN (column_name) - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

The column partition containing the column uses COLUMN format, if it is not already defined with COLUMN format.

You cannot include columns with the JSON data type in a join index. However, you can use extracted portions of a JSON document in an index. See Teradata JSON, B035-1150.

AUTO COMPRESS
The column partition containing the column use COLUMN format with autocompression.
NO AUTO COMPRESS
The column partition containing the column use COLUMN format without autocompression.