Share via


SqlTriggerType Enumeration

Defines the supported trigger types.

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)

Syntax

'Declaration
Public Enumeration SqlTriggerType
public enum SqlTriggerType
public enum class SqlTriggerType
type SqlTriggerType
public enum SqlTriggerType

Members

Member name Description
Unknown Specifies that the trigger type is unknown.
For Specifies that the Data Manipulation Language (DML) trigger is fired when the operations specified in the triggering Transact-SQL statement have executed.

AFTER is the default when FOR is the only keyword specified.

After Specifies that the DML trigger is fired only when all operations specified in the triggering Transact-SQL statement have executed successfully.
InsteadOf Specifies that the DML trigger is executed instead of the triggering SQL statement. This overrides the actions of the triggering statements.

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace