Is there any way for finding compressed columns in database with there values, like system table for compression columns and values?
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