Given a column name how can I find which tables in database contain that column?
database, mysql, sql
Solution
SELECT * FROM information_schema.columns WHERE COLUMN_NAME = 'mycolumn'
Problem
Given a column name how can I find which tables in database contain that column ? or alternatively How can I find that particular column exists for all tables in Database ? Note: Kindly explain answers with Examples as that I get most knowledge from the answer. Edit: I am using MySQL Database.