export data dictionary SQL 2005
Posted on 2011-02-12
Experts- I am looking for a way to export a view of all of our tables, columns, and relationships (data dictionary) to excel or visual format. I have a DB called "Test" that is fairly big. 240+ tables. The developer never created a formal DDL, and I am looking to create one, and be able to print if needed.
If there is a cut and paste script that i can append when i click "new query", that would be great. If there is any known good freeware, that is great also.
I attempted to use some freeware and it created 240 individual scripts. That will not do. If there is one script to extract the entire schema that would be best.