34,837
社区成员




use [数据库a]
select a.name 'TableName'
from sys.tables a
inner join sys.columns b on a.object_id=b.object_id
where b.name='fa'
DECLARE @t VARCHAR(10)
SET @t = 'fa' --字段名
SELECT a.name AS '表名'
FROM sysobjects a ,syscolumns b
WHERE a.id = b.id AND a.type = 'U' AND b.name = @t
select OBJECT_NAME(object_id) as tname,* from sys.columns where name='fa'