16.20 - Creating and Altering Tables to Store XML Data - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference
You can create tables containing XML type columns or alter a table to add, drop, or rename XML type columns:
  • You can specify the same CREATE TABLE or ALTER TABLE options that are permitted on the UDT types on the XML type.
  • You can use the CREATE TABLE statement to create a table that contains one or more XML type columns.
    You cannot use an XML type column in an index definition.
  • You can use the ALTER TABLE statement to add, drop, or rename an XML type column.
  • You can use ALTER TABLE to change the maximum length and inline storage length of an XML column subject to the following restrictions:
    • If the existing XML column type is a LOB type, you can only change the maximum length to a larger value.
    • If the existing XML column type is a nonLOB type, the newly changed data type must remain a nonLOB type, and the new maximum length and inline length values must be greater than the old values.

For details about CREATE TABLE and ALTER TABLE, see Teradata Vantageā„¢ SQL Data Definition Language Syntax and Examples, B035-1144.