Example: Using ISSCHEMAVALID to Check an XML Instance for Validity Against an XML Schema

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
SELECT customerID, customerXML.ISSCHEMAVALID(schematab.schemacontent, 'Customer', '')
FROM customer, schematab
WHERE schematab.schemaid = 'customerschema.xsd';

Query result:

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