SQL里能筛选出一部分没用的表吗？~

[ladyling]

有个数据库里有大概2000个表
但有80%是没数据的
我想找一些有用的数据，但不可能每个表逐个打开
请问怎么筛选掉一些空表

[Softlee81307]

Declare @s varchar(50),@p varchar(1000)
Declare kk cursor for
select name from sysobjects where xtype='U'
open kk
fetch next from kk into @s
while @@fetch_status=0
begin
set @p='if not exists(select * from '+@s +' ) select ''' + @s+''''
exec(@p)
fetch next from kk into @s
end
close kk
deallocate kk

[sdhdy]

select a.name 表名 from sysobjects a join sysindexes b on a.xtype='U' and a.status>0 and a.id=b.id and b.indid<2 and b.rows>0 order by a.name