Index.PartitionScheme-Eigenschaft

Artikel
07/31/2013

Gets or sets the partition scheme associated with the index.

Diese API ist nicht mit CLS kompatibel.

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

Syntax

'Declaration
<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 
    Get 
    Set
'Usage
Dim instance As Index 
Dim value As String 

value = instance.PartitionScheme

instance.PartitionScheme = value

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

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

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

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

Eigenschaftswert

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

Hinweise

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

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

Beispiele

Erstellen, Ändern und Löschen von Indizes

Siehe auch

Verweis

Index Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Indizes

CREATE INDEX (Transact-SQL)

Freigeben über