Monday, April 15, 2013

Can you compress a column which is already present in table using ALTER?

Can you compress a column  which is already present in table using ALTER?

No,   We cannot use ALTER command to compress the existing columns in the table.
A new table structure has to be created which includes the Compression values and data should be inserted into Compress column table.

Please note - ALTER can be used only to add new columns with compression values to table.