Thread: Creating a trigger on n tables?

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"
-----------------------------------------------------------------------------------------------

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