You can get portions (most) of it by reading it into the DataSet, adding the appropriate relationships, and calling DataSet.WriteXmlSchema. Tools like XML SPY and others can export database schemas as XML schemas as well.
Hope this helps, Bob Beauchemin [EMAIL PROTECTED] -----Original Message----- From: Jeff Fedor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 1:07 PM To: [EMAIL PROTECTED] Subject: [DOTNET] Slightly OT: XML Schema out of SQL? anyone know a quick and snappy way to get a database schema out of SQL as XML? thanks j You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
