MSSQL查看一个数据库中所有表的行数

4683 点击·0 回帖

灯火互联

楼主


	MSSQL查看一个数据库中所有表的行数 1: SELECT a.name, b.rows 2: FROM sysobjects AS a INNER JOIN 3: sysindexes AS b ON a.id = b.id 4: WHERE (a.type = 'u') AND (b.indid IN (0, 1)) 5: ORDER BY b.rows DESC 图片：20121007092714316.png

喜欢0 评分0

您需要登录后才可以回帖，登录或者注册