查询sqlserver表名，行数及表说明
SELECT D.NAME TABLE_NAME, B.ROWS TABLE_ROWS, F.VALUE TABLE_COMMENT
FROM SYSOBJECTS D
LEFT JOIN SYS.EXTENDED_PROPERTIES F ON D.ID = F.MAJOR_ID AND F.MINOR_ID = 0
LEFT JOIN SYSINDEXES B ON D.ID = B.ID AND B.INDID IN (0, 1)
WHERE XTYPE = 'U'
ORDER BY D.NAME
标签：NAME,sqlserver,及表,行数,TABLE,ID From： https://www.cnblogs.com/shichq/p/17329211.html