SQL structure to XML schema

[bharadwajrv]

i need to convert my SQL database (on MS SQL 2000) structure to a XML scheme file...

how to do it??

Thanks in Adv..
Cheers..
Venu

[George1111]

Not sure if this is what you need but it just may be !

Please let me know if it does what you need as I have not had a chance to test it as yet

Thanks

[TheCPUWizard]

As shown (dep withing George's sample)


Select * from Table FOR XML AUTO

is the magic SQL...