Stephen Hardy stephenhardy

## gist:ee2b0c1f31b26896179133dff12f7fcf
select
    t.name table_name
from
    sys.tables t
    join sys.schemas s on (t.schema_id = s.schema_id)
    join sys.partitions p on (t.object_id = p.object_id)
where p.index_id in (0,1)
group by t.name,s.name
having sum(p.rows) = 0;

## gist:5a30a948cd80d756897824d67510c8dd
openssl rand -base64 20
	select
	t.name table_name
	from
	sys.tables t
	join sys.schemas s on (t.schema_id = s.schema_id)
	join sys.partitions p on (t.object_id = p.object_id)
	where p.index_id in (0,1)
	group by t.name,s.name
	having sum(p.rows) = 0;