You can create tables containing JSON type columns or alter a table to add, drop, or rename JSON type columns:
- You can specify the same CREATE TABLE or ALTER TABLE options that are permitted on the UDT types on the JSON types.
- You can use the CREATE TABLE statement to create a table that contains one or more JSON type columns.You cannot use a JSON type column in an index definition.
- You can use the ALTER TABLE statement to add, drop, or rename a JSON type column.
- You can use ALTER TABLE to change the maximum length and inline storage length of a JSON column subject to the following restrictions:
- If the existing JSON column type is a LOB type, you can only change the maximum length to a larger value.
- If the existing JSON column type is a non-LOB type, the newly changed data type must remain a non-LOB type, and the new maximum length and inline length values must be greater than the old values.
- You cannot use ALTER TABLE to change the storage format of an existing column.
If you want to change the storage format of a JSON column, you must drop the column and add the column back specifying the new storage format.
For details about CREATE TABLE and ALTER TABLE, see Teradata Vantageā¢ - SQL Data Definition Language Syntax and Examples, B035-1144.