sqlserver查詢某個字段在哪些表中存在

    --含有醫(yī)院編號字段的所有表
    select a.[name] from sysobjects a,
    (
    select [id],count(*) b from syscolumns
    where [name] ='column1'
    group by [id]
    )
    b where a.[id]=b.[id] order by a.name asc
    --同時含有醫(yī)院編號和科室編號字段的所有表
    select a.[name] from sysobjects a
    left join
    (
    select [id],count(*) b from syscolumns where [name]
    in('column1','column2') group by [id] having count(*)>1
    ) b
    on a.[id]=b.[id]
    where b.id is not null