sql数据库,怎么查询出数据库中没有数据的表?
select sys.objects.namefrom sys.objects join sys.sysindexeson sys.objects.object_id=sys.sysindexes.idwhere indid<=2 and type='U'group by sys.objects.namehaving SUM(rows)=0
☞
☞
☞
☞
如果您觉得好看,请点个“在看”↓↓↓
select sys.objects.namefrom sys.objects join sys.sysindexeson sys.objects.object_id=sys.sysindexes.idwhere indid<=2 and type='U'group by sys.objects.namehaving SUM(rows)=0
☞
☞
☞
☞
如果您觉得好看,请点个“在看”↓↓↓