Solved

visual representation of the dependencies using phpMyadmin

Posted on 2004-09-07
1
322 Views
Last Modified: 2006-11-17
Hello ..I am relatively new to Mysql .I am using phpMyadmin as the graphical client.The database I working right now is pretty complex(I did not desgign it).I was wondering if there is any feature in phpMyadmin wherein I can see the structure of the tables in graphical form ...something like
an ER diagram..(like we see in SQL ..and in some clents in Oracle)

I appreciate your time.Would go a long way in helping me understand mysql db in general
0
Comment
Question by:micro_learner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 500 total points
ID: 12007253
I don't believe there is anything in phpMyAdmin to do it.  Part of the problem is that the default table type for MySQL doesn't enforce foreign keys.  Unless you are using InnoDB, MySQL has no idea what tables are linked to each other.  AFAIK, you'll have to draw such a diagram by hand.  You might import the tables into some tool like Access that has a quasi-decent relationship diagram editor, so all you have to do is drag and drop on the relationships.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question