Recipes for Continuous Database Integration: Evolutionary Database Development

Recipe 6Removing Database Objects

Problem: Removing just the applications database objects

When you're working with other teams in a shared deployment environment, you need to know how to safely remove just the database objects you created, not all database objects.

Solution

Removing the objects you created cleans your objects from a shared database and helps you determine which database objects your application depends on. Often your application depends on some trigger or view that team members keep forgetting to add, or they forget to remove a trigger when the application needs to be removed from the shared database. The following code example shows the Ant target DBClean, used to remove the database objects created by the DBInit target that ...