Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
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 ...
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