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

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"
;

 

posted @ 2014-07-21 14:32  xachary  阅读(171)  评论(0)  编辑  收藏  举报