Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |