Check.MarkForDrop Method (Boolean)


Marks the foreign key to be dropped next time its parent Table object is altered by the Alter method.

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

public void MarkForDrop(
	bool dropOnAlter


Type: System.Boolean

A Boolean value that specifies whether the check constraint is dropped when an Alter method is run on the parent SqlSmoObject object.

If True, the check constraint is dropped when the table is altered.

If False, the check constraint is not marked for drop.


For check constraints based on the UserDefinedTableType object this method generates an exception because user-defined data types cannot be modified.

Return to top