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

SQL Server

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

MySQL

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

 

转载于:https://www.cnblogs.com/xachary/p/3858368.html