Generate XSD from 2005 SQL Server Database

Posted by Robert Finlayson on Stack Overflow See other posts from Stack Overflow or by Robert Finlayson
Published on 2009-05-11T19:10:15Z Indexed on 2010/06/07 8:02 UTC
Read the original article Hit count: 188

Filed under:
|

What is the easiest method to generate an XSD schema from a 2005 SQL Server Database?

Would it be possible to generate one XSD schema for the entire Database (~100 tables)?

I searched online and found a SQL example that generates one XSD for the one table:

DECLARE @schema xml
SET @schema = (SELECT * FROM MyTableName FOR XML AUTO, ELEMENTS, XMLSCHEMA('MyTableNameSchema'))
SELECT @schema

Outside of SQL Server, is there a third party tool that could generate the XSD file from the 2005 Database?

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about xsd