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,

enter image description here

For bigger resolution, Please click here.

Thanks In advance.

Any help much more appreciated! :)

score 0 · Answer 1 · answered Oct 02 '12 at 04:29

0

MySQL Workbench is what youre looking for

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

answered Oct 02 '12 at 04:29

WebChemist

4,393
6
28
37

i am using putty / secure crt..how can i configure this? – Database Admin Oct 02 '12 at 05:05
You connect directly on 3306 or whatever your mysql port is. Need to have user access from the appropriate external ip, unless on the same machine as the db then just use localhost – WebChemist Oct 02 '12 at 05:12

score 0 · Answer 2 · edited May 23 '17 at 12:01

0

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.

edited May 23 '17 at 12:01

Community

1
1

answered Oct 02 '12 at 04:29

Bjoern

15,934
4
43
48

score 0 · Answer 3 · answered Oct 02 '12 at 06:23

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.

score 0 · Answer 4 · answered Oct 02 '12 at 06:27

0

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

answered Oct 02 '12 at 06:27

DocJones

649
7
26

score 0 · Answer 5 · answered Nov 04 '12 at 05:20

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

Tool for table_schema and table_name relationship

5 Answers5