Skip to Content

Why PowerDesigner compound triggers automaticaly generated when attaching sequences to columns

Hi,

I used PowerDesigner to reverseEngineer one of our huge database (we are moving data architecting from one software to PowerDesigner).

I am connecting my sequences to the right columns which weren't reverse engineered by default at first. Perhaps, I understand why.

As I fill the sequence field in the column's properties, I observed that PowerDesigner generate compound triggers (delete, insert, update and tib)

To my knowledge, those coumpound triggers aren't no more needed in Oracle and constitue archaic means of doing or in my language quite an arsenal for killing a fly.... so why is PD generating them automatically ?

Is it possible to remove or inactivate this automatic generation ? and if yes, how ?

I do have several huge models to work on and I wouldn't like to remove them one by one as I am actually connecting my sequences.

Thanks,

Annie Morin

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Posted on Jan 16 at 10:33 PM

    You can try this:

    Go to Tools->Resources->DBMS. Open Oracle DBMS.

    Select an item and open its property. In Body tab, remove the code you don't want.


    capture.png (46.2 kB)
    capture.png (46.2 kB)
    Add comment
    10|10000 characters needed characters exceeded