Schema Management | XML Data Type | Teradata Vantage - 17.10 - Schema Management - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Methods on the XML type such as CREATESCHEMABASEDXML and ISSCHEMAVALID take an XSD (XML Schema Definition) schema as a parameter and validate the XML type instance against it. Teradata recommends that you store the schemas as XML type values in tables with unique identifiers associated with them. When invoking a method that requires the schema as an input argument, you can join the schema table and specify the schema by its unique identifier in the WHERE clause.