XML Schema Creation in SQL Server 2005

Posted on September 7, 2011 by Matt

Here’s an interesting approach for creating a quick and dirty schema to get you started with XML.

DECLARE @schema xml
SET @schema = (SELECT * FROM schema.TABLE FOR XML AUTO, ELEMENTS,
XMLSCHEMA('SchemaName'))
SELECT @schema

I don’t have the source, but I have where I found it.

This entry was posted in SQL Toolbox and tagged sql server 2005, T-SQL, xml. Bookmark the permalink.