SELECT

    [Table Name] = OBJECT_NAME(c.object_id),

    [Column Name] = c.name,

    [Description] = ex.value

FROM

    sys.columns c

LEFT OUTER JOIN

    sys.extended_properties ex

ON

    ex.major_id = c.object_id

    AND ex.minor_id = c.column_id

    AND ex.name = 'MS_Description'

WHERE

    OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0

     AND OBJECT_NAME(c.object_id) = 'clue'  --表名

ORDER

    BY OBJECT_NAME(c.object_id), c.column_id