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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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;