Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Index.PartitionScheme Property

Gets or sets the partition scheme associated with the index.

This API is not CLS-compliant. 

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

<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
<SfcReferenceAttribute(GetType(PartitionScheme), "Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']",  _
	)> _
<CLSCompliantAttribute(False)> _
Public Property PartitionScheme As String 
Dim instance As Index 
Dim value As String 

value = instance.PartitionScheme

instance.PartitionScheme = value

Property Value

Type: String
A String value that specifies the partition scheme associated with the index.

This property cannot be modified by using the Alter method. To change the property, the index must be rebuilt or re-created.


For indexes based on the UserDefinedTableType object the value of PartitionScheme property is an empty string.

Community Additions

© 2015 Microsoft