The drop operation performs the following processes:
1 Sets an exclusive lock on the database.
2 Verifies that the database is empty.
If the database is not empty, then the DROP DATABASE action aborts.
3 Verifies that the database does not own any other databases or users.
If the database owns any databases or users, then the DROP DATABASE action aborts.
4 Drops the database.
5 Adds the PERM and TEMP space that the drop makes available to that of the immediate owner database or user.
After a database is dropped, you cannot recover it by using the Dump and Restore utility unless it is restored.