SELECT b.name AS tablename, a.rowcnt AS datacount FROM sysindexes a, sysobjects b WHERE a.id = b.id AND a.indid < 2 AND objectproperty(b.id, 'IsMSShipped') = 0 ORDER BY datacount DESC
转载于:https://my.oschina.net/mosg/blog/2253027
SELECT b.name AS tablename, a.rowcnt AS datacount FROM sysindexes a, sysobjects b WHERE a.id = b.id AND a.indid < 2 AND objectproperty(b.id, 'IsMSShipped') = 0 ORDER BY datacount DESC
转载于:https://my.oschina.net/mosg/blog/2253027