Question

SQL查询列名所在表

知道列名A，求所有列名所在的表

Answer 1

SELECT TABLE_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME = '列名'

Answer 2

select b.name as 表名,a.name as 列名

from sys.columns a join sys.tables on a.object_id=b.object_id
where a.name='列名'