Hi.....
Ques: Suppose I made an after Trigger on Delete. Now I fire Delete * From tablename. will this trigger work? Now do I fire truncate from table name (instead of delete command). will this trigger work now? If yes or no then why?
Loading
AartiPosted Dec 21, 2011, 1:20 AM
A TRUNCATE TABLE statement is in effect a DELETE statement, it does not activate a trigger because the operation does not log individual row deletions.
Pravin MorePosted Dec 20, 2011, 4:21 AM
yes it will work for Delete but TRUNCATE statements do not fire triggers.
Thanks,
Pravin.