All Forums Database
agts 5 posts Joined 03/13
07 Sep 2016
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
 
 

agts 5 posts Joined 03/13
07 Sep 2016

got it.
CompressValueList in dbc.columns can be use for same 
 
 

You must sign in to leave a comment.