查询某一列在哪些表中

select name 
from sysobjects a
where exists(
        select 1 from syscolumns b
        where name = 'customerid'
        and b.id =a.id
    )