How to find the rowcount of every table in your SQLServer database


A neat little script this. Speaks for itself. It returns the row count for each of the user table (xtype='U') for the database you run the script in.



select obj.[name], ind.rows
from   sysobjects obj
join   sysindexes ind
on     ind.ID = OBJECT_ID(obj.[name])
and    ind.indid < 2
and    obj.xtype = 'U'
order  by obj.[name]


del.icio.us this is del.icio.us