Index.PartitionScheme 속성

Gets or sets the partition scheme associated with the index.

이 API는 CLS 규격이 아닙니다. 

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(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 
    Get 
    Set
‘사용 방법
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)

속성 값

유형: System.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.

인덱스 생성, 변경 및 제거

참고 항목

참조

Index 클래스

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

인덱스

CREATE INDEX(Transact-SQL)