List compressed SQL tables

select 
 '[' + s.name + '].[' + o.name + ']' as TblName
 ,p.data_compression_desc
from 
 sys.partitions p
 join sys.objects o
  on p.object_id = o.object_id
 join sys.schemas s
  on o.schema_id = s.schema_id
where
 p.data_compression != 0