Tool for table_schema and table_name relationship

Question

Do you know any tools for profiling,to see the structure and relationship of each tables inside the db? it is look like this one :

See screenShot below,

For bigger resolution, Please click here.

Thanks In advance.

Any help much more appreciated! :)

Answer 1

Have a look at Database Designer for MySQL in dbForge Studio for MySQL.

Database Designer is a powerful visual design tool for database development that allows you to build a clear and effective database structure visually and to see the complete picture representing all the tables, foreign key relations between them, views, and stored routines of your database on database diagrams.

Answer 2

Toad for MySQL has a Database Diagram feature allowing you to create such drawings from existing databases.

Answer 3

MySQL Workbench is what youre looking for

http://www.mysql.com/products/workbench/

Answer 4

You could use the MySQL Workbench, if I remember correctly it has a function, which can do this (reverse engineer database or something similar).

See this SO post.

Answer 5

SchemaCrawler for MySQL is a free command-line tool that diagrams databases. SchemaCrawler is particularly useful when diagramming large and complex schemas, since it can diagram tables based on the results of regular expression searches of table and column names.

Sualeh Fatehi, SchemaCrawler