Specifies whether database tables and indexes for this object are compressed. When compression is enabled, tables and indexes created after that point are compressed. Tables and indexes created before that point remain uncompressed. Similarly, for an object store upgrade, the upgrader value of this property only impacts tables and indexes created during or after the upgrade.

If compression is enabled after a table has been created and then an index is created for that table, the index will be compressed while the table's compression state remains uncompressed. Likewise, if a table is created as compressed, then the compression mode is disabled, new indexes will not be compressed while the table remains compressed.

Before enabling this property, consider the following:

• If you require that existing tables and indexes also be compressed, you will have to compress those items manaully (with the SQL ALTER command). Refer to your database vendor's documentation.
• Some database vendors might require a separate feature license for database compression. Verify that you have the feature license installed before attempting compression.
• Some editions of a database product might not support database compression. Verify that the edition of your database product supports database compression.

For more information, see Database administrator installation tasks.

Property DatabaseCompressionMode As Nullable(Of DatabaseCompressionMode)

Nullable<DatabaseCompressionMode> DatabaseCompressionMode { get; set; }

property Nullable<DatabaseCompressionMode> DatabaseCompressionMode {
	Nullable<DatabaseCompressionMode> get ();
	void set (Nullable<DatabaseCompressionMode> value);
}

function get_databaseCompressionMode();
function set_databaseCompressionMode(value);