SQL Server queries all table names and rows of data

Query all indicates that the select name from sysobjects where xtype= ' u ' select * from sys.tables//queries the database for all table names and row counts select A.name, B.rowsfrom syso Bjects as a INNER JOIN sysindexes as B on a.id = b.idwhere (A.type = ' u ') and [B.indid in (0, 1)] ORDER by A.name,b.rows DE sc//query all marked and space consumption \ line number Selectobject_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 sysindexeswhere Indid=1order by Tablename,reserved desc

　　

SQL Server queries all table names and rows of data