Re: Data dictionary for MySQL

[Steve Edberg]

At 11:29 AM +0530 9/7/06, Ravi Kumar. wrote:
>Hi All,
>
>I am looking for a data dictionary for MySQL. It should be free and ideally,
>developed in php. And such that it stores the data dictionary in MySQL
>itself.
>
>Any suggestions / pointers?
>


If you're using MySQL5, take a look at the information_schema 
database; it might have everything you need already:

	http://dev.mysql.com/doc/refman/5.0/en/information-schema.html


steve

-- 
+--------------- my people are the people of the dessert, ---------------+
| Steve Edberg                                http://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center                            sbedberg@stripped |
| Bioinformatics programming/database/sysadmin             [phone] |
+---------------- said t e lawrence, picking up his fork ----------------+