SQL Server queries all table names and rows of data

1 //Query all indicateSelectName fromsysobjectswhereXtype='u'2 3 Select *  fromsys.tables4  //Querying all table names and rows in the database5 6 SELECTA.name, B.rows7 8  fromsysobjects asAINNER JOINsysindexes asB ona.ID=b.id9 Ten WHERE(A.type= 'u') and(B.indidinch(0,1)) One  A ORDER  byA.name,b.rowsDESC -  -  //query all indication and space consumption \ line number the  - Select -  - object_name(ID) tablename, +  - 8*Reserved/1024x768reserved, +  A RTrim(8*Dpages)+'KB'used, at  - 8*(Reserved-Dpages)/1024x768Unused, -  - 8*Dpages/1024x768-Rows/1024x768*Minlen/1024x768Free , -  - rows in  - --,* to  +  fromsysindexes -  the whereIndid=1 *  $ Order  byTablename,reserveddesc

View Code

SQL Server queries all table names and rows of data