16.20 - Examples: Adding and Removing the JSON Auto Column Option - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

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;