Recipes for Continuous Database Integration: Evolutionary Database Development

Recipe 7Removing Your Database

Problem: As with creating a database or schema, dropping a database or schema shouldn't be time-consuming

After you're done with a database or schema, you want to remove it, but you don't want to burden your DBA group. You want team members to handle maintenance tasks on their own, which frees the DBA group for important tasks.

Solution

The goal is to have a self-managing team that can take on responsibility for some maintenance tasks. Removing a database or schema that's no longer used can be automated by using an Ant target. If you want to rename your database or schema, you might have to drop and re-create it; this target can also be used for that purpose. The DBDrop target in the following code example uses ...