how can a specify header is in which table?

suppose i have three table with names : broker,man and coach.

i want to know that for example 'name' field

is in which table.

how can 开发者_运维问答realize it?

Strange question indeed.

select column_name,table_name 
from information_schema.columns
where table_schema = 'your_db' and table_name in ('broker','man','coach') and column_name = 'name'