sql 查询某个数据库中某一字段在哪个表里

[飞扬的雪花]

我现在想查找数据库a中，哪张表里存放着字段fa，返回表名，怎么用sql实现，求高手指点！！！

[开着拖拉机泡妞]

select OBJECT_NAME(object_id) as tname,* from sys.columns where name='fa'

[shinger126]

SQL2000用2楼的，2000以上的都可以用

[jiajiaren]

 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

[sdhp]

select name,OBJECT_NAME(id) as tablename from syscolumns where name='fa'

[wangrcaction]

select OBJECT_NAME(id)表名,name from syscolumns where name = '字段名'

[卖水果的net]

syscolumes , sysobjects

[唐诗三百首]

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'