1、--含有医院编号字段的所有表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 aleft join(select [id],count(*) b fro
2、m syscolumns where [name]in('HospitalId','DepartmentId') group by [id] having count(*)>1) bon a.[id]=b.[id]where b.id is not null
