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)

Syntax

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

value = instance.PartitionScheme

instance.PartitionScheme = value

[SfcReferenceAttribute(typeof(PartitionScheme), "Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']", 
    )]
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)]
[CLSCompliantAttribute(false)]
public string PartitionScheme { get; set; }

[SfcReferenceAttribute(typeof(PartitionScheme), L"Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']", 
    )]
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone)]
[CLSCompliantAttribute(false)]
public:
property String^ PartitionScheme {
    String^ get ();
    void set (String^ value);
}

[<SfcReferenceAttribute(typeof(PartitionScheme), "Server[@Name='{0}']/Database[@Name='{1}']/PartitionScheme[@Name='{2}']", 
    )>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)>]
[<CLSCompliantAttribute(false)>]
member PartitionScheme : string with get, set

function get PartitionScheme () : String
function set PartitionScheme (value : String)

Property Value

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

Remarks

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

Not

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

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

Index Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

CREATE INDEX (Transact-SQL)