-- 含有医院编号字段的所有表 select a . [name] 表名 from sysobjects a , ( select [id] , count (*) b from syscolumns where [name] = 'HospitalId' group by [id] ) b where a . [id] = b . [id] -- 同时含有医院编号和科室编号字段的所有表 select a .
-- 含有医院编号字段的所有表
select a . [name] 表名 from sysobjects a ,
(
select [id] , count (*) b from syscolumns
where [name] = 'HospitalId'
group by [id]
)
b where a . [id] = b . [id]
-- 同时含有医院编号和科室编号字段的所有表
select a . [name] 表名 from sysobjects a
left join
(
select [id] , count (*) b from syscolumns where [name]
in( 'HospitalId' , 'DepartmentId' ) group by [id] having count (*)> 1
) b
on a . [id] = b . [id]
where b . id is not null