select that return all tables with column description
SELECT
sys.objects.name AS [Table Name]
,sys.columns.name AS [Column Name]
,sys.extended_properties.value AS [Description]
FROM
sys.objects LEFT JOIN
sys.columns
ON sys.objects.object_id = sys.columns.object_id LEFT JOIN...