先尝试以下命令

snippet.sql

USE master
GO
DROP DATABASE testdb

如果仍然无法删除，可以在使用以下更强方法。

snippet.sql

USE master
GO
 
DECLARE @dbname sysname
SET @dbname = 'testdb' --要删除的数据库名
 
DECLARE @s nvarchar(1000)
DECLARE tb cursor LOCAL
FOR
  SELECT s = 'kill   ' + CAST(spid AS VARCHAR)
  FROM master.dbo.sysprocesses
  WHERE dbid = DB_ID(@dbname)
OPEN tb
fetch NEXT FROM tb INTO @s
while @@fetch_status = 0
BEGIN
  EXEC (@s)
  fetch NEXT FROM tb INTO @s
END
close tb
deallocate tb
 
EXEC ('drop database [' + @dbname + ']')