Book a Demo

Author Topic: DDL Sequence naming conflicts  (Read 3051 times)

jklap

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
DDL Sequence naming conflicts
« on: October 14, 2011, 10:24:45 pm »
Under Oracle, multiple tables with similar names and similar PK names results in the generate of sequences with the same names:

Table 1:
TaxonomyGroup w/PK named PKTaxonomyGroup_id

Table 2:
TaxonomyGroupLink w/PK named PKTaxonomyGroupLink_id

Both generate a sequence named:
SEQ_TaxonomyGroup_PKTaxonomyGr

EA 9.1 build 909