SQL --

How to know Table rows in db?
select o.name, rows
from sysindexes i join sysobjects o on o.id=i.id
where indid < 2 and type='U'
order by rows