sql语句查询列的说明

SELECT C.name,value FROM sys.columns C INNER JOIN sys.tables T ON C.object_id = T.object_id
INNER JOIN sys.extended_properties  P ON p.minor_id=c.column_id AND p.major_id=C.object_id
 WHERE T.name='SalesSupOrderB' 

posted @ 2013-08-12 14:48  pengbg  阅读(493)  评论(0编辑  收藏  举报