System Table for Compression

Database
Enthusiast

System Table for Compression

Is there any way for finding compressed columns in database with there values, like system table for compression columns and values? 

using

Select * from dbc.columns where compressible like 'C%';

I can get the list of compressed columns along with database and tables, but I am looking out for easy way to get all compressed values with databasename, table, column names and compressed value list.

Please comment. Thanks in advance

1 REPLY
Enthusiast

Re: System Table for Compression

got it.

CompressValueList in dbc.columns can be use for same