To work in existing DBs is sometimes very hard, if you do significant changes at the table-structure because there could be a lot dependencies in SPs or views.
It would be very useful to set the DB in a state where you can do every change without checking existing dependencies.
While doing changes only the touched objects will be checked if they are valid and only before bringing the DB online the complete DB will be compiled and checked if there are invalid dependencies.