Finding Which Tables Reference Column in Given Table in MySQL

Posted on April 7, 2017 by Marcin Kossakowski
Tags: mysql, tips-and-tricks

When dealing with schema updates in MySQL I often have to check what foreign key constraints are in place. How can we find which table have columns that reference the primary column on the table we’re modifying. Here’s the SQL statement that will help us find those references.