摘要： 查出所有的空表 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 阅读全文