Examples: Adding and Removing the JSON Auto Column Option - Advanced SQL Engine - Teradata Database

Here is the table definition for these examples.

CREATE TABLE MyTable (
a INTEGER, 
b INTEGER, 
c JSON(64000) CHARACTER SET LATIN AUTO COLUMN);

This statement removes the auto column capability from column c.

ALTER TABLE MyTable 
c JSON(64000) CHARACTER SET LATIN NOT AUTO COLUMN;

This statement adds the column j with the JSON data type, a 4K byte length, BSON storage format, auto column capability, and a default value of NULL.

ALTER TABLE MyTable 
ADD j JSON(64000) STORAGE FORMAT BSON AUTO COLUMN NULL;