sql 查询数据库的常用脚本

查询数据库的所有表的记录数

 

----查询所有表的记录数量----------------------------------------------------------------------------------
select   a.name as 表名,max(b.rows) as 记录条数   from   sysobjects   a   ,sysindexes   b     
  where   a.id=b.id   and   a.xtype='u'   
group   by   a.name   
order by max(b.rows) desc
----------------------------------------------------------------------------------------------------------------------