select
ROW_NUMBER() OVER (ORDER BY a.object_id) AS No,a.name AS Name,
isnull(g.[value],'无') AS Remark
from
sys.tables a left join sys.extended_properties g
on (a.object_id = g.major_id AND g.minor_id = 0)
select
ROW_NUMBER() OVER (ORDER BY a.object_id) AS No,on (a.object_id = g.major_id AND g.minor_id = 0)