Query for existing foreign keys

Discussion in 'MySQL' started by jestep, Jul 13, 2009.

  1. #1
    Does anyone know how to search for tables that have a foreign key relationship with another table across an entire database.

    I can easily see what foreign keys a single table has on other tables, but I really need to see all tables that have a foreign key relationship with a particular table. Basically a reverse foreign key search. If anyone knows a query or script to do this, let me know.

    Also, this is for MySQL...

    Thanks
     
    jestep, Jul 13, 2009 IP