SELECT 'alter table ' + QUOTENAME(a.name) + '.' + QUOTENAME(b.name) + '
REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE);
'
FROM sys.schemas a
JOIN sys.all_objects b ON a.schema_id = b.schema_id
AND b.type = 'u'