根据字段名称查找所在的表名

SELECT name
FROM sys.sysobjects SO
WHERE EXISTS
(
    SELECT *   
    FROM   syscolumns SC
    WHERE  name LIKE 'Reason'
    AND SC.id = SO.id
)

USE `XXX`;
SELECT *
FROM `information_schema`.`columns`
WHERE `TABLE_SCHEMA` = "YYY"
AND COLUMN_NAME = "MemberID"
;