共用方式為


Index.MarkForDrop 方法

Marks the index to be dropped the next time that the Alter method is run on the Index object's parent object.

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

語法

'宣告
Public Sub MarkForDrop ( _
    dropOnAlter As Boolean _
)
'用途
Dim instance As Index 
Dim dropOnAlter As Boolean

instance.MarkForDrop(dropOnAlter)
public void MarkForDrop(
    bool dropOnAlter
)
public:
virtual void MarkForDrop(
    bool dropOnAlter
) sealed
abstract MarkForDrop : 
        dropOnAlter:bool -> unit  
override MarkForDrop : 
        dropOnAlter:bool -> unit
public final function MarkForDrop(
    dropOnAlter : boolean
)

參數

  • dropOnAlter
    型別:System.Boolean
    A Boolean value that specifies whether to drop the index the next time the parent object is altered.If True, the index is dropped when the parent is altered. Otherwise, False.

實作

IMarkForDrop.MarkForDrop(Boolean)

備註

[!附註]

Indexes based on the UserDefinedTableType object cannot be modified and running this method will generate an exception.

範例

建立、改變和移除索引

請參閱

參考

Index 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

索引

DROP INDEX (Transact-SQL)