Share via

TriggerType Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:
Microsoft.SqlServer.TransactSql.ScriptDom.dll
Package:
Microsoft.SqlServer.DacFx.x64 v140.3881.1
Package:
Microsoft.SqlServer.DacFx v150.5282.3
Package:
Microsoft.SqlServer.DacFx v160.6161.0
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
Package:
Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

Specifies the type of the trigger.

[System.Serializable]
public enum TriggerType
[<System.Serializable>]
type TriggerType = 
Public Enum TriggerType
Inheritance
Enum
TriggerType
Attributes
SerializableAttribute

Fields

Name Value Description
Unknown 0

Unknown
For 1

For behaves exactly as After.
After 2

Specifies that the trigger is fired only when all operations specified in the triggering SQL statement have executed successfully. All referential cascade actions and constraint checks also must succeed before this trigger executes.
InsteadOf 3

Specifies that the trigger is executed instead of the triggering SQL statement, thus overriding the actions of the triggering statements.

Applies to