共用方式為


Index.IsDisabled 屬性

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

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property IsDisabled As Boolean 
    Get
'用途
Dim instance As Index 
Dim value As Boolean 

value = instance.IsDisabled
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool IsDisabled { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool IsDisabled {
    bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member IsDisabled : bool
function get IsDisabled () : boolean

屬性值

型別:System.Boolean
A Boolean value that specifies whether the index is disabled.If True, the index is disabled. Otherwise, False (default).

備註

[!附註]

For indexes based on the UserDefinedTableType object the value of IsDisabled is provided by sys.indexes and the value of IsDisabled property is ignored.

範例

建立、改變和移除索引

請參閱

參考

Index 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

索引

CREATE INDEX (Transact-SQL)