SQL structure to XML schema

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

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

As shown (dep withing George's sample)

Code:

---

Select * from Table FOR XML AUTO

---

is the magic SQL...