Script SQL Table Schema as XML-XSD

  • Brandon Forest

    SSCommitted

    Points: 1827

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

  • Brian W. Smith

    Grasshopper

    Points: 13

    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

    Thanks for the script.

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

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