Msg 3702, Level 16, State 3, Line 2
Cannot drop database “DataBaseName” because it is currently in use.
This is a very generic error when DROP Database is command is executed and the database is not dropped. The common mistake user is kept the connection open with this database and trying to drop the database.
The following commands will raise above error:
USE AdventureWorks; GO DROP DATABASE AdventureWorks; GO
The following commands will not raise an error and successfully drop the database:
USE Master; GO DROP DATABASE AdventureWorks; GO
If you want to drop the database use master database first and then drop the database.
Reference : Pinal Dave (https://blog.sqlauthority.com)