Post reply

Script SQL Table Schema as XML-XSD

  • October 8, 2009 at 4:12 am

    #211989

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

  • 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.

  • May 23, 2016 at 4:57 pm

    #1880930

    Thanks for the script.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply