Sql Server查找包含某字段的表
//查询数据库中包含某个字段的所有表
select * from eCheck.dbo.sysobjects where id in (select id from echeck.dbo.sysColumns where name like '%userNo%')
//查询数据库中包含某个字段的所有表
select * from eCheck.dbo.sysobjects where id in (select id from echeck.dbo.sysColumns where name like '%userNo%')