日期:2014-05-18 浏览次数:20552 次
select distinct a.name from sys.objects a join sys.sysindexes b on a.OBJECT_id=b.id where a.type='U' and b.rows=0
------解决方案--------------------
use [数据库A] select a.name from sys.objects a inner join sys.sysindexes b on a.object_id=b.id where a.type='U' and b.indid=1 and b.rows=0