drop database because it is currently in use

USE Master; 
GO
  
ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
GO
 
-- and finally 
DROP DATABASE DatabaseName  
GO