请问在数据库中，如何查找出有“**”字段的表

[wangchangming]

在一个庞大的数据库中，请问：我如何知道在哪些表中定义到Cincode字段。

[marco08]

select sysobjects.name from syscolumns
inner join sysobjects on syscolumns.id=sysobjects.id
where syscolumns.name='Cincode'

[fish_yht]

ls好快
刚看还没人呢
进来搞定了

[gc_ding]

--查已知列名的情况
select b.name as tbleName, a.name as columnname
From syscolumns a, sysobjects b
where a.id=b.id and b.type='U' and a.name='Cincode'

--查未知列名的情况
select o.name as tablename, s1.name as columnname
from syscolumns s1, sysobjects o
where s1.id = o.id
and o.type = 'U'
and Exists
( select 1 from syscolumns s2 where s1.name = s2.name and s1.id <> s2.id)

[bugchen888]

SELECT object_id(id)
FROM syscolumns
WHERE name='Cincode'

[studenthj]

select object_id(id)
from syscolumns
where name='Cincode'

[renfeiyang]

收藏

[jackeyabc]

select sysobjects.name from syscolumns
inner join sysobjects on syscolumns.id=sysobjects.id
where syscolumns.name='Cincode'