Get All Tables With RowCount

Following query will return all table’s name with rowcount from a database.

SELECT sysobjects.[name],  Max(sysindexes.rows) AS Rows
FROM  sysobjects  INNER JOIN sysindexes ON
sysobjects.id = sysindexes.id WHERE sysobjects.xtype = 'U'
group by sysobjects.[name] 

Advertisement

« ASP.NET MVC or Web Form

Custom ASP.NET MVC Authorize Attribute »