How many rows in all tables in a DB?

[TheJFM]

Hi

I know I should know this but ... how do I get the number of rows per table back quickly from a database?

Ta

** Don't reach for the moon when you have the stars. ;-) TheJFM **

 

[nigelrivett]

select o.name, rows from sysindexes i, sysobjects o where i.indid in (0,1) and o.id = i.id and o.xtype = 'U'

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[TheJFM]

Thanks!!

** Don't reach for the moon when you have the stars. ;-) TheJFM **