Maybe we should keep top posting for consistency in this particular thread? Case Studio 2 does not appear to be free. Toad seems to be Windows only and no ER Diagramming? I use dbdesigner, but manually draw the relations (I believe this is since MySQL <= 3.23.58; MySQL <= 4.0.17 did not have referential integrity?) I'll have to see how to setup 4.1 for this. Hi Costa, Thanks for ur comment. I also found 2 tools for this regard, 01) Case Studio 2 (http://www.newfreedownloads.com/Software-Developer/Miscellaneous/CASE-Studio-2.html ) 02) Toad (http://www.quest.com/toad-for-mysql/ ) Thanks, Lasitha. From: Rafael Costa Pimenta [mailto:rcphelp@xxxxxxxxx] Sent: Sunday, October 21, 2007 1:50 AM To: Lasitha Alawatta Subject: Re: ER Diagramming tool for MySQL you could use dbdesign, download in http://superdownloads.uol.com.br/download/140/dbdesigner/ 2007/10/20, Lasitha Alawatta < Lasitha.A@xxxxxxxx>: Hi All, Does anyone know of a GOOD ER Diagramming tool for MySQL? I would preferably a free/open source one. Regards, Lasitha DOTW DISCLAIMER: This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you must not disclose, copy or take any action in reliance of this transmission and you should notify us as soon as possible. If you have received it in error, please contact the message sender immediately. This e-mail and any attachments are believed to be free from viruses but it is your responsibility to carry out all necessary virus checks and DOTW accepts no liability in connection therewith. This e-mail and all other electronic (including voice) communications from the sender's company are for informational purposes only. No such communication is intended by the sender to constitute either an electronic record or an electronic signature or to constitute any agreement by the sender to conduct a transaction by electronic means. _________________________________________________________________ Help yourself to FREE treats served up daily at the Messenger Café. Stop by today. http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline