SQL Server queries all table names and rows of data

Query all indicate
Select name from sysobjects where xtype= ' u '

SELECT * FROM Sys.tables

Querying all table names and rows in the database

SELECT A.name, B.rows

From sysobjects as a INNER joins sysindexes as B on a.id = b.ID

WHERE (A.type = ' u ') and (B.indid in (0, 1))

ORDER by A.name,b.rows DESC

Query all indication and space consumption \ line number

Select

object_name (ID) tablename,

8*reserved/1024 reserved,

RTrim (8*dpages) + ' KB ' used,

8* (reserved-dpages)/1024 unused,

8*dpages/1024-rows/1024*minlen/1024 free,

Rows

--,*

From sysindexes

where indid=1

ORDER BY tablename,reserved Desc

SQL Server queries all table names and rows of data