Does TDM really have no concept of proper order of generation of tables? Do I really have to manually specify that order? Isn’t it clear that if there’s a chain of FK references that the generation should occur such that the FK referenced tables are generated FIRST? I see no particular reason why that couldn’t be automated from information in the model.
can you send me your model, please? And would you please describe what problems the default ordering makes?
SQL code generated by Toad Data Modeler contains all table creation statements at beginning and all relationships are created at the end of the script. There should be no problem.
Please send us your model and additional information to firstname.lastname@example.org. Thank you.