在SqlServer数据库怎么查询某个字段在哪些表中出现过

Select a.name as Columns, b.name as TableName from syscolumns a
left join sysobjects b on a.id = b.id
Where b.type = 'U' and a.name ='Book_Code' order by b.name

b.type='U' (表),  b.type='V' (视图)