foreign key

March 28, 2014 / 1 min read

MySQL See all columns and tables that foreign key to a table or column

If you're trying to understand how an existing database has been setup it can be very useful to see all of the tables/columns that foreign key into some other table/column. use INFORMATION_SCHEMA; select TABLE_NAME,CO...