How to generate ERD/UML for a database which has lost its primary key and foreign key information?

Viewed 78

I have with me the table creation scripts of a well structured database. BUT, For some reason lets say, the table creation scripts does not contain the primary key or foreign key information.

What is the best way to generate a ERD/UML for the database created using these scripts - assuming the indexes are intact. Is there any tool available to check the names of columns and generate the ERD/UML?

Should I do this manually?

2 Answers
Related