Go SQL Server 2005 queries the number of database tables and the amount of data in the table

This article was reproduced from: http://hi.baidu.com/ajyajyajy/item/4e2a7f4dc83393d2c1a592c1

Use DBNAME
Go
SELECT * from sysobjects where xtype= ' U '; --This is information for querying all tables
Select COUNT (*) from sysobjects where xtype= ' U '-this is the number of query tables

Select A.name, b.rows from sysobjects A with (NOLOCK) joins sysindexes B with (nolock) on b.id=a.id where a.xtype= ' U ' and B. Indid in (0,1) Order BY a.name ASC-This is a quick query of the amount of data in all tables