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