Database objects like Schema already implement drop() method to delete them. To simplify usage, we should let the DatabaseObject interface extend AutoClosable, so that you can use them in try-with-resources blocks. Then they are automatically deleted without explicitly dropping them.

Implementation could be done with minimal effort by adding void close() to DatabaseObject with a default implementation that just calls drop().