根据列名找表

[sp_maoqi]

给定条件：列名
要求：根据列名查找出“列名”所在的表

[云中客]

select b.name as 表名,a.name as 列名 from syscolumns a,sysobjects b where a.id=b.id and a.name='列名'

[gahade]

select * from sysobjects where id in (select id from syscolumns where name = '列名')

[marco08]

select sysobjects.name from sysobjects
inner join syscolumns on sysobjects.id=syscolumns.id
where syscolumns.name='字段名'

[sp_maoqi]

各位老大，你们那个不对啊。
在麻烦你们帮帮忙，小弟在此，谢了。

select * from wtzc32base..sysobjects a,wtzc32base..syscolumns b
where b.name = 'fundlocation'
and a.id = b.id

我觉得表wtzc32base..sysobjects
和wtzc32base..syscolumns 中的id是两马事，你们觉得呢？

[xyxfly]

select * from sysobjects where id in (select id from syscolumns where name = '字段名'

??这样不行吗？

[xyxfly]

还有 楼主说的


select * from wtzc32base..sysobjects a,wtzc32base..syscolumns b
where b.name = 'fundlocation'
and a.id = b.id
这样有什么不对呀？ 我觉得要说不对的话那可能是楼主需求提的有问题哦 ：）

[sp_maoqi]

真不好意思，是我搞错了。

[liangpei2008]

Select Object_Name(ID) as '所属表名' From SysColumns
Where Name='您的字段名'

[sp_maoqi]

结贴
怎么样结的啊？
我好给分啊

[liangpei2008]

本贴右上方管理-给分！

[gahade]

没关系

结贴就好了!:)

[kisa99]

select * from sysobjects where id in (select id from syscolumns where name = '列名' ) and (xtype='u' or xtype='s') order by name

[十一月猪]

select object_name(id) as 表名 from syscolumns
where name = colname