Partilhar via

DataCompressionType Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo
Assembly:
Microsoft.SqlServer.SqlEnum.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

DataCompressionType describe about the compression status of a table/index partition. None means no compression, Row means compression row wise,Page means compression applied page wise and ColumnStore is compression columnstore wise

public enum DataCompressionType
type DataCompressionType = 
Public Enum DataCompressionType
Inheritance
Enum
DataCompressionType

Fields

Name Value Description
None 0

No data compression for this object
Row 1

Row compression is set for this object
Page 2

Page compression is set for this object
ColumnStore 3

ColumnStore compression, default for columnstores
ColumnStoreArchive 4

ColumnStore archival compression mode

Applies to