title: SQL Server Extract Data Model
body: <p>Is there a simple way of extracting the database model of existing DBs? I played around in the management studio and in Visio, even though I found very interesting features of data integration I failed to perform a simple export of the structure of the DB.</p>
  
  <p>Could anyone pls give me a hint how to perform such an export, basically I only need the table and view names and their fields in a Visio or Enterprise Architect readable format.</p>
  
  <p>thx in advance</p>
  
  <p>K </p>