Creating a trigger on n tables?
Creating a trigger on n tables?
От:
Bjørn T Johansen <btj@havleik.no>
Дата:
Is there an easier way to create the same trigger for n tables or do I need to run create trigger n times? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bjørn T Johansen btj@havleik.no ----------------------------------------------------------------------------------------------- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" -----------------------------------------------------------------------------------------------
Re: Creating a trigger on n tables?
От:
Richard Huxton <dev@archonet.com>
Дата:
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
