The generated DDL script does not create the entities / relationships in the correct order. It creates the objects out of dependency order. For example, the view WaterUseView relies on WaterUseNonCentralView. However, the WaterUseView comes first in the create order. Thus, the create script cannot be used. There are several stored Procedures that run into this same problem.
TDM cannot always detect correct dependencies, especially when the object with hard-coded SQL statements is used e.g. procedures, functions, and some database views. For these instances, the user can change the order manually.
To change the order of generated objects, either click on Model | Order of generated objects… OR try to generate SQL code, then on the second tab (Detail Settings Tab), click the Edit button, and then sort the items using the up & down arrows.
