SELECT b.name as TableName,a.name as columnname From syscolumns a INNER JOIN sysobjects b ON a.id=b.id where b.type=‘U‘ AND a.name=‘destid‘
T-SQL实用查询之查询字段所属的数据库表
原文：https://www.cnblogs.com/coce/p/10173422.html
