Scripting database objects in dependency order
We're building a new application on SQL 2005, requiring a new database and objects. I'm making frequent changes to the objects, often making a specific change to all of the tables. In SQL 2000 I would just script out the database, make my change, and apply the script (assuming that the tables are empty or can be easily refilled).
When I script out the objects in SQL 2005 I get an option to generate create or drop statements, but not both (if exists... drop table). More importantly, the objects aren't scripted in dependency order (i.e. the customer table must be created first but deleted last).
Am I missing something? Is there an option on the scripting wizard to give me the functionality like it was in SQL 2000? Is there anything else I can try, besides writing my own scripting app?
Thanks for listening!