Altering the Compression Level of a Database

Changing a database's compression level does not change the compression level of existing tables in the database; only tables you create after you alter the database inherit the new compression level.

Alter the compression level of existing databases using:
alter database database_name
 […]
set 
    [[,] compression = {none | row | page}]

See the Reference Manual: Commands.

To alter the pubs2 database to use page-level compression, use:
alter database pubs2 
set compression = page
Parent topic: Creating Databases for Data Compression