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.