Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 RecordCount from all tables.

Author  Topic 

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2001-09-21 : 07:32:58
Hi,
I have 200 tables in my database.
I want to create a report which shows

TableName Total Records
==========================
T1 20001
T2 12
T3 3244

Likewise....

I want to ask that, is there any system table where database management system stores the record count for each table Object?

Thanx in Advance


---------------------------
Sandesh - The Messanger
   

- Advertisement -