一、查看表名和对应的数据行数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 ...
时光匆匆，记录是对思维的沉淀；
一、查看表名和对应的数据行数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 ...