Creating and Altering Tables to Store XML Data | Teradata Vantage - Creating and Altering Tables to Store XML Data - Analytics Database - Teradata Vantage

XML Data Type

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
2023-10-30
dita:mapPath
tkc1628112506748.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dgs1472251600184
lifecycle
latest
Product Category
Teradata Vantage™
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.