SQL-DMO
AfterTrigger Property
The AfterTrigger property indicates whether a trigger is an AFTER trigger.
Applies To
Trigger2 Object |
Syntax
object.AfterTrigger
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
Boolean
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetAfterTrigger(LPBOOL pRetVal);
Remarks
AFTER triggers fire after the triggering action (INSERT, UPDATE, or DELETE) and after any constraints have been processed. AFTER triggers can only be created on tables.
All triggers created using Microsoft® SQL Server™ version 7.0 or earlier are AFTER triggers.
Note If an application calls AfterTrigger on an instance of SQL Server7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.