查找表中列名包含某字符的所有表
select * from sysobjects ,syscolumns
where sysobjects.id = syscolumns.id and syscolumns.name like '%customerId%'
查找表中列名包含某字符的所有表
select * from sysobjects ,syscolumns
where sysobjects.id = syscolumns.id and syscolumns.name like '%customerId%'