0

I am looking for a schematic diagram of an existing database. More precisely, I wan't to re-create the database model / schematics / the Entity Relationship Diagram (ERD) showing all the links between the tables of this existing database in MYSQL,I am using MYSQL workbench as an IDE,does it have database modelling tools to extract this?if not what other tools can do this?

UPDATE:

enter image description here

  • @RafaelPiccinelli - This is MYSQL database and am using MYSQL workbench IDE..I dont see such an optioin to create database diagram?which tool are you referring/? – user3508811 Jun 20 '17 at 14:14
0

You can use Reverse Engineer under Database menu:

enter image description here

You just need to rearrange the tables.

  • I used that and it created a diagram for me,I see dotted lines and solid lines,where can I find the LEGEND on what these lines mean?I updated a screen shot of my diagram – user3508811 Jun 20 '17 at 14:25
  • Also,is there a way to save the diagram? – user3508811 Jun 20 '17 at 14:27
  • 1
    did you search for something before posting here? You can find a lot of videos on youtube, like this one: youtube.com/watch?v=RMxr5j83dcg – Racer SQL Jun 20 '17 at 14:29
  • and those are your tables, you need to rearrange them ( I see now your update ) – Racer SQL Jun 20 '17 at 14:30
  • 1
    Please, you can google all these questions. Make a little search inside the manual. You can easily find all your answers. it's good to not extend a discussion in comments. – Racer SQL Jun 20 '17 at 14:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.