I’ve been tasked with creating a query that will return following data:

[Schema Name], [Object Name], [Extended Property Name], [Extended Property Value]

Any ideas how to accomplish this? I’ve found fn_listextendedproperty function but that doesn’t help much.

sql-server
Edit
Report