Qry to get table name and size in records

[cricketer1]

How do I write a query to get table names and there sizes (# of records) in a database. What sys tables and columns should I query.

Thanks
cricketer1

 

[osjohnm]

Hi cricketer1

This should help you:

select o.name as "Table Name",i.rowcnt as "Row Count"
from sysobjects o, sysindexes i
where i.id = o.id
and indid in(0,1)
and xtype = 'U'
order by o.name

Hope this helps

John

 

[cricketer1]

it works just fine!!
thanks