Book a Demo

Author Topic: DDL Script does not consider FKs in DROP stmts  (Read 2906 times)

AndreasBuschka

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
  • I love YaBB 1 Gold!
    • View Profile
DDL Script does not consider FKs in DROP stmts
« on: August 02, 2003, 06:04:26 am »
I have a diagramm for my Oracle Schema, containing lots of foreign keys. When I tell enterprise architect to create DROP statements for my SQL script, the DROP statements try to drop tables that are still referenced by other tables, causing ORA-02449 errors. How can I set EA so that it creates correct DROP scripts?

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: DDL Script does not consider FKs in DROP stmts
« Reply #1 on: August 03, 2003, 03:40:27 pm »
The order of DDL drop statements is an issue that is currently under review. It will be addressed in a future release of EA.