1、查询数据库中所有表:
select name from sysobjects where xtype='U';
2、查询数据库中所有表的记录数量:
select a.name, b.rows from sysobjects a inner join sysindexes b on a.id = b.id where a.type = 'u' and b.indid in (0, 1) order by a.name
1、查询数据库中所有表:
select name from sysobjects where xtype='U';
2、查询数据库中所有表的记录数量:
select a.name, b.rows from sysobjects a inner join sysindexes b on a.id = b.id where a.type = 'u' and b.indid in (0, 1) order by a.name