select object_name(id) as tablename,rows from sysindexes
where id in (select id from sysobjects where xtype='U') and indid in (0,1)
mssql2000中查询某一数据库中所有表和表的记录数
最新推荐文章于 2023-09-27 16:32:21 发布
select object_name(id) as tablename,rows from sysindexes
where id in (select id from sysobjects where xtype='U') and indid in (0,1)