Order of Views in DDL

[bernhard795]

Hi,

I'm currently facing a problem using EA for database design. I have several views that depend on each other like:

Code: [Select]

CREATE View1 AS SELECT ... FROM Table1, Table2
/

CREATE View2 AS SELECT ... FROM View1, Table3
/

Sadly, EA doesn't seem to offer a way to set the order in which these views have to be created. I've already set dependencies, to show EA which view has to be created first, but EA doesn't seem to use those for generation of the DDL.

So the script contains the statement for View2 followed by the statement for View1, which makes my database return an error that a table or view doesn't exist.

Any hints, suggestions, ideas?

Thank you and best regards
 Bernhard