SQL Server database views the number of records for each table

1. number of records in each table

Select A.name as Table name , Max (b.rows) as number of record strips From sysobjects A, sysindexes b
where a.id=b.id and a.xtype= ' u '
GROUP BY A.name
ORDER by Max (b.rows) desc

2. Total number of records

Select SUM( number of records ) as total record Count from(

　　Select Top 10000 a. Name as table name ,Max(b. Rows) as record number from sysobjects a ,sysindexesb

　　where a. ID=b. ID and a. Xtype=' u '

　　Group by a. Name

　　Order by Max(b. Rows) desc

)T1

SQL Server database views the number of records for each table