Sometimes, it could be handy to know in which tables a certain column name is specified. To do so, use the query below.
1 2 3 4 |
select distinct table_name from information_schema.columns where column_name in ('columnA','ColumnB') and table_schema = 'YourDatabase'; |
Note: you need to fill in your own column names and table_schema. Enjoy!