查找整个数据库里某个字段在哪些表里

select sysobjects.name from syscolumns inner join sysobjects on syscolumns.id=sysobjects.id where syscolumns.name= '你想查找的字段'

 

select [name],create_date,modify_date FROM sys.all_objects order by modify_date