SqlServer 获取 表 以及 表的 说明

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)

  where a.name not in('sysdiagrams','ASPStateTempSessions','ASPStateTempApplications');