请大家帮，帮，帮，帮个忙！！！

[laoer_2002]

怎么查找出数据库里记录数大于1W的表？？？

先谢谢大家了！

[loverforever]

select indentity(int,1,1) id, * into #tem from tablename
select * from @tem where id>10000
drop table @tem
go

[txlicenhe]

不知道除了用select count(*) from yourTable一个个找之外还有什么好的办法，关注ing...

[pengdali]

select a.name 表名,b.rows 记录数 from sysobjects a join sysindexes b on a.xtype='U' and a.status>0 and a.id=b.id and b.indid<2 where b.rows>1000000...