Christopher Shaw
Find Tables By Column Name In Mysql Database
Posted on Monday 21st January 2019 in Snippet

The following query allows you to identify tables which contain a specific column, this can be helpful when working with larger databases which reference common field names which are not actually foreign keys. An example of this would be a user_id which is used on a user table, and other tables which can be tied to a specific user.

SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%column_name%'
AND TABLE_SCHEMA=’database_name’;