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)