March 24, 2021 at 1:39 pm
Hi,
I need to get the XSD for an XML field on a table. I know I can take the XML and generate the XSD online.
But is the XSD for the field stored in the DB and how do I get to it?
Would the one I generate be the same as the one stored? Sorry I'm not up on XSD.
Thanks
March 24, 2021 at 2:40 pm
Ideally from the source/designer of the XML. Barring that, maybe Generate an Inline XSD Schema
Here's another link: Generate XSD from Sql query using FOR XML
March 31, 2021 at 1:09 pm
Is there a schema collection in the database? Sounds like there is because you say the XSD is stored in the database.
You need to query the database schema collection, I think. Not sure if this is what you're looking for:
If there is no schema collection then your XML is "untyped", and if you want a schema for validating the XML, you'll have to get that from an external source (either generate yourself, or get from someone else).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply