SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Database Engine)

SQL Server Management Objects

SQL Server Management Objects Reference

Microsoft.SqlServer.Management.Smo

Trigger Class

Trigger Methods

Alter Method

Create Method

Drop Method

Initialize Method

MarkForDrop Method

ReCompileReferences Method

Script Method

ScriptHeader Method

Minimize

This topic has not yet been rated - Rate this topic

Trigger.MarkForDrop Method

SQL Server 2012

Marks the trigger to be dropped.

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

public void MarkForDrop(
	bool dropOnAlter
)

Parameters

dropOnAlter: Type: System.Boolean
A Boolean value that specifies whether to drop the trigger next time the Alter method is run on the parent object.If True, the trigger is dropped when the Alter method of the parent object is run.If False, the trigger is not dropped on alter.

Implements

IMarkForDrop.MarkForDrop(Boolean)

Creating, Altering, and Removing Triggers

Reference

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TRIGGER (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.