Outputting Data Dictionary and Schema

[rrancani]

I am taking over a very well NON-documented SQL server based database at work. How can I easily print a Data dictionary and schema? I know I can look at the tables seperately in the Enterprise manager but I would like to export all the table definitions to a file so I can print a copy for quick reference.

Any help is appreciated!

 

[foxdev]

You can use the Diagram feature in EM, though it is not terribly robust.

What I've always used is ERWin or some other ERD tool and reverse-engineered from the existing database. Unfortunately, those tools are not cheap. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com