TableCompressionType Enumeration

The TableCompressionType enumeration provides options for what type of compression is used on the specified table.

Enumeration Values

Name	Summary
None	Specifies that the table or index will not be compressed.
Row	Specifies that the table or index will be compressed so that rows can be individually added or removed.
Page	Specifies that the table or index will be compressed so that entire storage pages must be compressed as a unit. A page will consist of many rows.
ColumnStore	Specifies that the table or index will use column store compression.
ColumnStoreArchive	Specifies that the table or index will use column store archival compression.