title: SQL Server : report of referenced tables & foreign keys
body: <p>I'd like to generate a report that displays all the tables in the database. For each table, the report would document the tables it is referencing, and the tables it is referenced by. Also included, is the foreign key used for referencing.</p>
  
  <p>I've tried using <a href="http://www.red-gate.com/products/sql-development/sql-dependency-tracker/" rel="nofollow">Red Gate SQL Dependency Tracker</a> previously, and it gave me an easy-to-read, usable report--what was lacking was just the foreign key for each table association.</p>
  
  <p>If anyone could be a great alternative software that could do what I want to do, or provide some form of an alternative method, I'd be very grateful! My main purpose of this is actually to provide the customer with some form of a readable schema, so that the customer can understand the interconnections within the DB... I've tried using database diagrams but that was a no-go due to the readability.</p>
  
  <p>Thanks!</p>