Index.IsUnique 속성

  • 아티클

Gets or sets the Boolean property value that specifies whether the index is unique or not.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design Or SfcPropertyFlags.Deploy)> _
Public Property IsUnique As Boolean 
    Get 
    Set
‘사용 방법
Dim instance As Index 
Dim value As Boolean 

value = instance.IsUnique

instance.IsUnique = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Deploy)]
public bool IsUnique { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design|SfcPropertyFlags::Deploy)]
public:
property bool IsUnique {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Deploy)>]
member IsUnique : bool with get, set

function get IsUnique () : boolean 
function set IsUnique (value : boolean)

속성 값

유형: System.Boolean
A Boolean value that specifies whether the index is unique or not.If True, the index is unique.If False (default), the index is not unique.

주의

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

예

인덱스 생성, 변경 및 제거

참고 항목

참조

Index 클래스

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

관련 자료

인덱스

CREATE INDEX(Transact-SQL)