Re: [sqlite] Database triggers

On Jun 29, 2009, at 2:44 PM, Kris Groves wrote: > Given the trigger creation statement : > CREATE TRIGGER triggername DELETE ON tablename BEGIN statements; END > > When does it happen ? BEFORE or AFTER ? > > I've read http://sqlite.org/lang_createtrigger.html, but it is > unclear to me. If I

[sqlite] Database triggers

Given the trigger creation statement : CREATE TRIGGER triggername DELETE ON tablename BEGIN statements; END When does it happen ? BEFORE or AFTER ? I've read http://sqlite.org/lang_createtrigger.html, but it is unclear to me. If I had to guess, I would say the trigger is a BEFORE trigger, but