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
"Anger makes you smaller, while forgiveness forces you to grow beyond what you were."
You are 3564 reader
since 1st April 2009
Yes | 0 | |
No | 0 |