Index.HasCompressedPartitions Property

Gets or sets the Boolean property value that specifies whether the index has compressed partitions.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property HasCompressedPartitions As Boolean 
    Get
'Usage
Dim instance As Index 
Dim value As Boolean 

value = instance.HasCompressedPartitions
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public bool HasCompressedPartitions { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property bool HasCompressedPartitions {
    bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member HasCompressedPartitions : bool
function get HasCompressedPartitions () : boolean

Property Value

Type: System.Boolean
A Boolean value that specifies whether the index has compressed partitions. If True, the index has compressed partitions. Otherwise, False (default).

Remarks

The partitions are identified by the PhysicalPartitionCollection.

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

Index Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

CREATE INDEX (Transact-SQL)