--这个根据存储区来判断
select B.name from sys.partitions A inner join sys.objects B
on A.object_id=B.object_id
where B.type='U' and A.rows>0
--这个根据索引表来判断
select B.name from sysindexes A inner join sys.objects B
on A.id=B.object_id
where B.type='U' And A.rows >0
追问大哥,执行结果对啊,太感谢了