Creating and Altering Tables to Store XML Data | Teradata Vantage - 17.10 - Creating and Altering Tables to Store XML Data - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)
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 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.

For more information about CREATE TABLE and ALTER TABLE, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.