Creating a trigger on n tables?

Started by Bjørn T Johansenabout 20 years ago2 messagesgeneral
Jump to latest
#1Bjø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"
-----------------------------------------------------------------------------------------------

#2Richard Huxton
dev@archonet.com
In reply to: Bjørn T Johansen (#1)
Re: Creating a trigger on n tables?

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