sql语句:
SELECT
top 1000 ROW_NUMBER() OVER ( ORDER BY a.object_id ) AS xh,
a.NAME AS table_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
)
这个是之前在网上找到的,但是现在找不到原网站了