在sqlserver中查找某个字段存在于那个表中的语句是：

use testgoselect a.Name as tableName from sysobjects a inner join syscolumns b on a.ID=b.IDwhere b.Name='列名'

 

例句：

use DigSmart70FLgoselect a.Name as tableName from sysobjects a inner join syscolumns b on  a.ID=b.ID where b.Name='DtReceived'