17.10 - Example: Using ISSCHEMAVALID to Check an XML Instance for Validity Against an XML Schema - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Last Update
2021-07-28
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)
Last Update
2021-07-28
SELECT customerID, customerXML.ISSCHEMAVALID(schematab.schemacontent, 'Customer', '')
FROM customer, schematab
WHERE schematab.schemaid = 'customerschema.xsd';

Query result:

customerID   customerXML.ISSCHEMAVALID(schemaContent, 'Customer', '')
----------   --------------------------------------------------------
         1                                                          1