Trigger - Table Name - Generalise!

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Fri, 27 Aug 1999 16:54:55 GMT
Message-ID: <7q6fsr$qi9$1@nnrp1.deja.com>

There are few tables with identical table structure. And an INSERT TRIGGER needs to be attached with each of these tables at ROW LEVEL. The trigger checks that if the current insert caues a duplicate, updates one of the fields in the old record.

... so the logic inside the trigger is same except for the table name. Is there a way to pass the table name or reference the table name inside body of trigger, so that i can write one TRIIGER and attach it with all tables!!

Thanks!

--
Nandakumar
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 11:54:55 CDT