Post reply

XSD Schema

  • October 24, 2007 at 11:34 pm

    #183150

    I have an XML file that has data from a couple of tables.

    How do I create an XSD for this XML file?

    Is there a native way to do this with T-SQL/SQL Server 2005 or do I have to use a 3rd party product?

    Kindest Regards,

  • October 25, 2007 at 12:02 am

    #745220

    Yes you can...

    select XMLColumn1, XMLColumn2

    from XMLTable

    FOR XML AUTO, ELEMENTS, XMLSCHEMA ('Product')

    --Ramesh

  • October 25, 2007 at 5:37 pm

    #745522

    Thanks for that.

    However, your code not only produced the XSD Schema but it also contains the data as well.

    Is this correct as I was under the idea that an XSD ONLY defines the structure NOT contain the data?

    Or have i got that incorrect?

    Kindest Regards,

  • October 26, 2007 at 3:31 am

    #745623

    Just add a WHERE clause such as 1 = 2 or TOP 0 in SELECT to return no rows...

    --Ramesh

  • October 29, 2007 at 1:03 am

    #746098

    Ok thanks Ramesh.

    Kindest Regards,

Viewing 5 posts - 1 through 4 (of 4 total)

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