Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

Are they any tools to extract out the relationships in a MyISAM database into an ER diagram?

I understand that MyISAM doesn't have foreign keys, but the columns in my database that represent foreign key relationships share the same names between tables. Are there any programs that can reverse engineer the schema into a ER diagram?

share|improve this question
I have done something similar a year or two ago. I'll try to dig up the script. The operation is not / cannot be fully automated though. – ypercube Jun 14 '12 at 7:34
Try mysql workbench -> reverse engineer – user9398 Jun 14 '12 at 9:52
   
@k8v Please don't put very short comments as answers. I realize you can't post comments yet, but that doesn't make it acceptable to post non-answers as answers. – JNK♦ Jun 14 '12 at 10:08
@k8v: Workbench cannot guess on FK constraints that have not been defined. – ypercube Jun 14 '12 at 10:29

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.