Script SQL Table Schema as XML-XSD

• Brandon Forest

  SSCommitted

  Points: 1977

  More actions

  October 8, 2009 at 4:12 am

  #211989

  Comments posted to this topic are about the item Script SQL Table Schema as XML-XSD

• Brian W. Smith

  Grasshopper

  Points: 13

  More actions

  October 28, 2009 at 10:03 am

  #1071873

  Just a note, you can change the element names if necessary for obfuscation with aliases as well, for example:

  SELECT TOP 0 [ID] = MemberAddrID

  , [Address1] = Addr1

  , [Address2] = Addr2

  , [Address3] = Addr3

  , [City]

  , [State] = ST

  , [Zipcode] = Zipcode

  FROM dbo.MBR_ADDR AS [MEMBER_ADDRESS]

  FOR XML AUTO, XMLSCHEMA;

  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.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 23, 2016 at 4:57 pm

  #1880930

  Thanks for the script.