extended-props-list.sql

declare @prefix varchar = 'MyApp_'
select
    tbl.name [table],
    col.name [column],
    ep.name,
    ep.value [value]
from sys.extended_properties ep
    inner join sys.objects tbl on tbl.object_id = ep.major_id
    left outer join sys.columns col on col.object_id = ep.major_id and col.column_id = ep.minor_id
where ep.name like @prefix + '%'
order by tbl.name, ep.minor_id