Book a Demo

Author Topic: Oracle DDL sequence generation  (Read 2059 times)

Steve Williams

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Oracle DDL sequence generation
« on: April 02, 2008, 09:26:56 pm »
I am trying to generate DDL for an Oracle database. The EA model I am generating from has auto-number columns so that it will generate sequences. I do, however, had a couple of issues with this.

First off I only seem to be able to generate sequences if I also generate triggers - the help states that this is what it is suppose to do. I don't want triggers however, only the sequences as our own procedures/scripts will make use of the sequences directly.

Secondly I don't seem to be able to control the DDL template for sequences in the same way as I can with keys and constraints. This has resulted in about fifty percent of my sequences (and related but unwanted triggers) to have the same name and therefore fail.

Any assistance or timelines to when these things might be changed would be greatly appreciated. Thanks in advance.

EA version 7.1.827