there is always something to develop
How to get number of records in each table in database
To get record rumber from all tables in database You just need to execute script bellow:
SELECT sysobjects.name as TableName, max(sysindexes.rows) AS TableRows FROM sysindexes INNER JOIN sysobjects ON sysindexes.id = sysobjects.id WHERE sysobjects.xtype = 'U' GROUP BY sysobjects.name ORDER BY max(sysindexes.rows) DESC
There is an assumption made, that each table has at least one index created.
See also
Comments
"Most people will be about as happy, as they decide to be. "
You are 3613 reader
since 1st April 2009
Yes | 0 | |
No | 0 |