Alternatives
Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
19 Feb 2010Md. Marufuzzaman
This is good... You can also consider this link.[^]
Sometimes it is necessary to have the schema name included as well. I concatenate with the table name for my convenience, but it is not vital to do so.SELECT sys.sysindexes.rows, sys.schemas.name + '.' + sys.objects.nameFROM sys.objectsINNER JOIN sys.schemasON ...
16 Aug 2011thatraja 4 alternatives
The below query can be used to get the record count of all tables in the current database.
Number of different ways to get total number of rows from tables
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.