在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' (视图)