1
2
3
4
select t.name TableName, i.rows Records
from sysobjects t, sysindexes i
where t.xtype = 'U' and i.id = t.id and i.indid in (0,1)
order by Records DESC;
origin - http://www.pipiscrew.com/?p=2276 sql-count-rows-for-each-table
1
2
3
4
select t.name TableName, i.rows Records
from sysobjects t, sysindexes i
where t.xtype = 'U' and i.id = t.id and i.indid in (0,1)
order by Records DESC;
origin - http://www.pipiscrew.com/?p=2276 sql-count-rows-for-each-table