Hello, for some reason Modeler uses the exact same name for tables sharing the same sequence/trigger. This is broken DDL script generation, because oracle does not allow two triggers of the same name in one schema. So as of this time, the DDL generator is broken for me, as I have over 30 tables with 2 triggers per table for a total of 60 triggers I have to modify due to the modeler
Steps to reproduce.
- Create a sequence SEQ_SCHEMA.
- Create a table with an Integer PK, have it use the sequence.
- Create another table like above.
- Generate DDL Script.
The result is broken script, as you have 2 sets of triggers, that are duplicated names.
PS: I would of posted this in the enhancement forums, but unfortunately, I no longer have access to post there (it seems). It keeps error out saying no such resource.