Make a data dictionary from phpmyadmin

andieje
andieje used Ask the Experts™
on
Hi

i think its all in the title.  I need a document with one section per database table giving the conceptual meaning of each field in the table

It seems you can as this guy cant print his
http://sourceforge.net/p/phpmyadmin/bugs/3271/

if it matters my phpmyadmin is is xampp

thanks expert elucidators
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
I looked at 5 different versions of phpMyAdmin including XAMPP and I can't find anything that says "data dictionary" in any of them.  I did find a reference online to "data dictionary" in phpMyAdmin 2.6.0... where are you seeing this?

Author

Commented:
I was just assuming it was standard being as your fields can have comments. I asssumed theyd have a ncie way to let  you print them off in a document. But it was an assumption
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
Well, you aren't necessarily wrong but I thought you already had something to work with.  It is an interesting idea, I'll do a little more research.  There are a number of pages with comments about the subject.
Fixer of Problems
Most Valuable Expert 2014
Commented:
It turns out that phpMyAdmin does have something it calls a "Data Dictionary" but it's only for each database, not for the entire server.  On the page that lists all the tables in a database, there is a "Data Dictionary" link near the bottom.  It will produce an HTML page with all the info.  You would have to print it out yourself.  See below:
phpMyAdmin "Data Dictionary" link

Commented:
I recommend you using a proper Data Dictionary generator. Here is a list:
http://datadictionarytools.dataedo.com/data-dictionary-tools-for-mysql

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial