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
"To have a right to do a thing is not at all the same as to be right in doing it."
You are 3353 reader
since 1st April 2009
Yes | 0 | |
No | 0 |