一、查看表名和对应的数据行数select a.name as '表名',b.rows as '表数据行数' from sysobjects a inner join sysindexes b on a.id = b.id where a.type = 'u' and b.indid in (0,1) --and a.name not like 't%' order by b.rows ...
一、查看表名和对应的数据行数select a.name as '表名',b.rows as '表数据行数' from sysobjects a inner join sysindexes b on a.id = b.id where a.type = 'u' and b.indid in (0,1) --and a.name not like 't%' order by b.rows ...