获取数据库每个表 及表的行数

---获取数据库中每个表的行数declare @sql nvarchar(max) set @sql=''select @sql=@sql+'select '''+cast(name as varchar(50))+''' as tablename, count(*) as rows from ' + name+ ' union all ' from sysobjects where xtype= 'u ' select @sql= left(@sql,len(@sql)-15) +' order by rows desc 'exec (@sql)