mssql获取表名及注释的SQL

SELECT obj.name AS [TableName],pro.value AS [Description] FROM sys.objects obj LEFT JOIN sys.extended_properties pro ON obj.object_id=pro.major_id WHERE obj.type='u'有个缺点就是把字段注释也取到了...

SELECT obj.name AS [TableName],pro.value AS [Description] FROM sys.objects obj LEFT JOIN sys.extended_properties pro
ON obj.object_id=pro.major_id
WHERE obj.type='u'