[font="Courier New"]SELECT  SCHEMA_NAME(tbl.schema_id) AS [Table_Schema],

        tbl.name AS [Table_Name],

        clmns.name AS [Column_Name],

        p.name AS [Name],

        CAST(p.value AS SQL_VARIANT) AS [Value]

FROM    sys.tables AS tbl

        INNER JOIN sys.all_columns AS clmns ON clmns.OBJECT_ID=tbl.OBJECT_ID

        INNER JOIN sys.extended_properties AS p ON p.major_id=clmns.OBJECT_ID

                                                   AND p.minor_id=clmns.column_id

                                                   AND p.class=1

ORDER BY [Table_Schema] ASC,

        [Table_Name] ASC,

        [Column_ID] ASC,

        [Name] ASC

[/font]