Count the number of records per table in the SQL Server database

Count the number of records per table in a SQL Server database use Jydb--Jydb for your database goselect b.[name] ' table name ', max (a.rowcnt) ' Record count ' from Sysinde Xes A join sys.objects B on b.object_id=a.id where b.type= ' U ' GROUP by B.[name]

This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://pizibaidu.blog.51cto.com/1361909/1683669

Count the number of records per table in the SQL Server database