SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Brandon Forest / Script SQL Table Schema as XML-XSD / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:04:44 GMT20RE: Script SQL Table Schema as XML-XSDhttp://www.sqlservercentral.com/Forums/Topic799844-1398-1.aspxJust a note, you can change the element names if necessary for obfuscation with aliases as well, for example:[code="sql"]SELECT TOP 0 [ID] = MemberAddrID , [Address1] = Addr1 , [Address2] = Addr2 , [Address3] = Addr3 , [City] , [State] = ST , [Zipcode] = ZipcodeFROM dbo.MBR_ADDR AS [MEMBER_ADDRESS]FOR XML AUTO, XMLSCHEMA;[/code]You're not locked into just following table's structure, you can do this on views as well, nice to see this article since its something that a lot of people don't know about or don't think regularly about.Wed, 28 Oct 2009 10:03:55 GMTBrian W. SmithScript SQL Table Schema as XML-XSDhttp://www.sqlservercentral.com/Forums/Topic799844-1398-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/XML/68390/">Script SQL Table Schema as XML-XSD</A>[/B]Thu, 08 Oct 2009 04:12:44 GMTBrandon Forest