create table with JSON datatype

Database
Enthusiast

create table with JSON datatype

Hi Experts,

I am unable to create a table with JSON datatype column. My TD version is 14.0.0.1

CREATE volatile TABLE my_table (eno INTEGER, edata JSON(100)) on commit preserve rows;

Error:

---------------------------

Teradata SQL Assistant

---------------------------

3706:  Syntax error: Data Type "JSON" does not match a Defined Type name. 

---------------------------

OK   

---------------------------

1 REPLY
Supporter

Re: create table with JSON datatype

JSON was introduced at TD15.0 - so it is not available at the 14.0...