Posts count rows for each table
Post
Cancel

count rows for each table

snap171

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

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags