查找表中列名包含某字符的所有表

查找表中列名包含某字符的所有表

select * from sysobjects ,syscolumns?

where sysobjects.id = syscolumns.id and syscolumns.name like '%customerId%'