Trigger Constants (SQLDMO_TRIGGER_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Trigger constants enumerate the kind of Transact-SQL data modification statement that causes a trigger to fire.
Microsoft SQL Server cursors can fire when an INSERT, UPDATE, or DELETE statement modifies data in a table on which an enabled trigger is defined. Separate triggers can be created to implement behavior for any one or a combination of Transact-SQL data manipulation language (DML) statements.
Constant |
Value |
Description |
|---|---|---|
SQLDMOTrig_All |
7 |
The trigger is fired by any data modification statement. |
SQLDMOTrig_Delete |
4 |
The trigger is fired by a DELETE statement. |
SQLDMOTrig_Insert |
1 |
The trigger is fired by an INSERT statement. |
SQLDMOTrig_Unknown |
0 |
The value is not valid. |
SQLDMOTrig_Update |
2 |
The trigger is fired by an UPDATE statement. |