15.10 - ADD COLUMN (column_name) - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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.