|Subject||Re: Get SQL Query in Trigger|
> Is it possible to get the SQL Statement which causes the execution ofNo you can't.
> a trigger in the trigger script ?
> for example:
> I perform: UPDATE test SET field=1 WHERE id=5
> so I want to get this string in a variable when the Trigger for Update
> Statements is fired for the table test.
You can look at the old and new values for each field and from that
generate a statement, but that is not the quite same thing, might be
close enough for your needs though.