Thread: rename table and triggers

rename table and triggers

From
Michele Petrazzo - Unipex
Date:
Hi list,
now I just uncovered  a strange behavior from my point of view: I have a
table with a trigger associated with its insert. If I rename that table,
the trigger "follow" its parent.
Are this a wanted and the normal behavior? Are there somewhere a
documentation about?

Thanks,
Michele

Re: rename table and triggers

From
Vick Khera
Date:
On Fri, Jun 18, 2010 at 1:41 PM, Michele Petrazzo - Unipex
<michele.petrazzo@unipex.it> wrote:
> now I just uncovered  a strange behavior from my point of view: I have a
> table with a trigger associated with its insert. If I rename that table, the
> trigger "follow" its parent.

The trigger is connected to the table, not the name of the table.  It
doesn't care what the name is.