Example: Using ISSCHEMAVALIDATED to Check if an XML Value is a Validated, Type-annotated Value

Teradata Vantage™ XML Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K
SELECT customerXML.ISSCHEMAVALIDATED()
FROM customer
WHERE customerID = 1;

Query result:

customerXML.ISSCHEMAVALIDATED()
-------------------------------
                              0