Sqlserver删除空表

查出所有的空表

select distinct a.name AS 表名 ,b.rows AS 表数据条数
from sys.objects  a,sysindexes b
where a.object_id=b.id and a.type='u' 
and b.rows = 0