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.

Post a Comment