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. |