select a.name as 表名, g.*from sysobjects as a left join syscolumns as b on a.id=b.id left JOIN sys.extended_properties g on b.id=g.major_id and b.colid=g.minor_id where b.name=‘CSProjectID‘
sql2008 查询字段所属表
原文：http://www.cnblogs.com/wolf12/p/4235640.html
