Export (0) Print
Expand All

Index.MarkForDrop Method

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public void MarkForDrop(
	bool dropOnAlter
)

Parameters

dropOnAlter
Type: 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.

Implements

IMarkForDropMarkForDrop(Boolean)

NoteNote

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft