在SqlServer数据库怎么查询某个字段在哪些表中出现过Select a.name as Columns, b.name as TableName from
在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' (视图)