Use "DatabaseName"

Select a.Name, b.rows from sysobjects a, sysindexes b where a.type='u' and
a.id=b.id and b.indid<2 order by a.Name

I think it will surve your purpose

Thanks & Regards
----------------------------------------
M. Eswar Kumar
Database Administrator
GE Plastics, Pittsfield
DC: *838 5736





-----Original Message-----
From: Andrews, Daryl [mailto:[Email Address Removed] Monday, January 26, 2004 1:07 PM
To: LazyDBA.com Discussion
Subject: Row count for all tables


I'm trying to find short SQL command that will provide the row count for all
tables in a database.

Any ideas?

Thanks,

Daryl

MS Sql Server LazyDBA home page