Bjørn T Johansen wrote:
Is there an easier way to create the same trigger for n tables or do I need to run create trigger n times?
You'll need to run CREATE TRIGGER several times I'm afraid. You might be able to wrap this in a function if you'd like though.
-- Richard Huxton Archonet Ltd