Scripts to list all SQL tables and their extended properties

SELECT SCHEMA_NAME(T.schema_id) AS SchemaName, 
       OBJECT_NAME(EXP.major_id) AS TableName, 
       EXP.value                 AS PropertyValue
FROM   sys.extended_properties AS EXP
LEFT JOIN sys.tables T
ON T.object_id = EXP.major_id
WHERE EXP.class_desc = 'OBJECT_OR_COLUMN'
AND EXP.name = 'Comments'
ORDER BY SchemaName, TableName