From: Ben Clewett
Date: May 10 2006 11:04am
Subject: Reporting child tables referencing a parnet table
List-Archive: http://lists.mysql.com/mysql/197846
Message-Id: <4461C8DB.6070806@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear MySQL,

Can you please tell me if there is a way of listing all child tables 
which have a foreign key reference to a parent?

Therefore I can find and delete a child row, then delete the parent 
without getting:

"a foreign key constraint fails"

Regards,

Ben Clewett