贴一个查询SQL Server数据库中所有表及其描述(Description)的SQL语句

select sys.tables.name, sys.extended_properties.Value
from sys.extended_properties,sys.tables
where minor_ID=0
    and sys.extended_properties.Major_ID=sys.tables.Object_ID
    and sys.extended_properties.name='MS_Description'
order by sys.tables.name