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

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
amr1556233250442.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1140
lifecycle
previous
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.