|
Home > Archive > MS SQL XML > October 2005 > XSD for SQL2K tables
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
XSD for SQL2K tables
|
|
| prefersgolfing 2005-10-27, 9:26 am |
| Is there an easy way, either using OPENXML or FOR XML, to create an XSD for
a SQL2K table or view?
| |
| Michael Rys [MSFT] 2005-10-27, 9:26 am |
| The SQL Server 2005 FOR XML RAW and AUTO modes will have an inline XSD
generation option.
In SQL Server 2000, the best way to get an XSD is either to take the XDR
that you can generate with FOR XML and run it through an XDR to XSD
transformation (there used to be an XSLT stylesheet that was able to do so),
or use xsd.exe on example FOR XML result data.
Best regards
Michael
"prefersgolfing" < prefersgolfing@hotma
il.com> wrote in message
news:OVcxmhX2FHA.3156@TK2MSFTNGP10.phx.gbl...
> Is there an easy way, either using OPENXML or FOR XML, to create an XSD
> for a SQL2K table or view?
>
|
|
|
|
|