title: how to create XML schema from an existing database in SQL Server 2008
body: <p>Is there a way to create an XML schema from an existing database in SQL Server 2008, SQL Server Management Studio? </p>
  
  <p>I have a DB with ~50 tables. I'm looking to create a "nice" diagram showing the relationship between those tables. Using another application called SQL Designer (<a href="https://code.google.com/p/wwwsqldesigner/">https://code.google.com/p/wwwsqldesigner/</a>) will give me the "nice" looking picture, but I don't know how to create the XML schema required.</p>
  
  <p>I did a search across the forum (and MS) and couldn't quite find my answer. I could find tools which created a database, but I'm looking at the reverse... I need a pretty picture which shows the database in diagrammatic form. I thought if I could get my db structure into XML then SQL Designer will do the rest for me.</p>
  
  <p>Thanks for your assistance.</p>
  
  <p>Nick</p>