列出表和表的扩展属性

我认为下面实现了你想要的，我的表上没有任何适合条件的扩展属性，因此很难检查它是否有效：

SELECT TABLE_NAME AS tTableName, 
    TABLE_TYPE AS tTableType,
    q.epTableName,
    q.epExtendedProperty
FROM information_schema.tables AS t
    LEFT OUTER JOIN (SELECT OBJECT_NAME(ep.major_id) AS [epTableName],
        CAST(ep.Value AS nvarchar(500)) AS [epExtendedProperty]
        FROM sys.extended_properties ep
        WHERE ep.name = N'MS_Description' AND ep.minor_id = 0) As q
    ON t.table_name = q.epTableName 
WHERE TABLE_TYPE = N'BASE TABLE'
ORDER BY TABLE_NAME