Example: HELP TABLE with a JSON Auto Column - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

Here is the table definition of MyTable for this example, where the JSON column c is defined with the AUTO COLUMN option.

CREATE TABLE TEST.MyTable (
 a INTEGER,
 b JSON(16776192) INLINE LENGTH 4096 CHARACTER SET LATIN,
 c JSON(16776192) INLINE LENGTH 4096 CHARACTER SET LATIN AUTO COLUMN)
PRIMARY INDEX ( a );

This statement displays information for the table MyTable.

HELP TABLE MyTable;

Below is the abbreviated HELP TABLE output for selected attributes of column c.

Column Name c
Type JN
Nullable Y
Format X(64000)
Max Length 16,776,192
Table/View? T
Inline Length 4,096
Auto Column Y