How can I dump my SQL Server Database Schema to a human readable & printable format?
- by Kyle West
I want to generate something like the following:
LineItems
Id
ItemId
OrderId
Price
Orders
Id
CustomerId
DateCreated
Customers
Id
FirstName
LastName
Email
I don't need all the relationships, the diagram that will never print correctly, the metadata, anything. Just a list of the tables and their columns in a simple text format.
Has anyone done this before? Is there a simple solution?
Thanks,
Kyle