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'
转载于:https://www.cnblogs.com/bingguang/p/3252909.html