USE [dbname];
ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

USE [master];
DROP DATABASE [dbname];

ALTER DATABASE dbName SET MULTI_USER WITH ROLLBACK IMMEDIATE

USE master;

DECLARE @dbname sysname

Set @dbname = 'DATABASE_NAME_HERE-PROD'

Declare @spid int
Select @spid = min(spid) from master.dbo.sysprocesses
where dbid = db_id(@dbname)
While @spid Is Not Null
Begin
        Execute ('Kill ' + @spid)
        Select @spid = min(spid) from master.dbo.sysprocesses
        where dbid = db_id(@dbname) and spid > @spid
End

ALTER DATABASE dbName
SET SINGLE_USER WITH ROLLBACK IMMEDIATE

delete DATABASE ...

ALTER DATABASE dbName
SET MULTI_USER WITH ROLLBACK IMMEDIATE