查找所有表含有某个字段(id_ep_contract_header)的表
select a.[name] 表名 from sysobjects a,
(
select [id],count(*) b from syscolumns
where [name] ='id_ep_contract_header'
group by [id]
)
b where a.[id]=b.[id]
查找所有表含有某个字段(id_ep_contract_header)的表
select a.[name] 表名 from sysobjects a,
(
select [id],count(*) b from syscolumns
where [name] ='id_ep_contract_header'
group by [id]
)
b where a.[id]=b.[id]