How can I get an XML Schema (XSD) from SQL Server?
This question has come up a few times, so here is the answer...
Example: To retrieve the XSD for the 'Order' table you can run:
Select * from [order] where ID < 0 FOR XML AUTO, XMLSCHEMA
This will just return the XSD (as the where clause will not return any order records).
Example: To retrieve the XSD for the 'Order' table you can run:
Select * from [order] where ID < 0 FOR XML AUTO, XMLSCHEMA
This will just return the XSD (as the where clause will not return any order records).
Labels: SQL Server, Transact SQL, XSD
posted by
Liquid Technologies
at
6:04 PM
