Script SQL Table Schema as XML-XSD

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

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

  • 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