查询sqlserver列名，行数及表说明

查询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