azure - 在 SSMS 中使用 T-SQL 删除 Azure SQL 数据库

Question

我无法在 SSMS 中DROP Azure SQL 数据库

   DROP DATABASE xxxx

并得到这个异常

Msg 42019, Level 16, State 4, Line 2
DROP DATABASE operation failed. Internal service error.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.

Answer 1

如果您连接到 xxxx 数据库，则无法从内部执行删除数据库。您需要连接到master db，然后执行DROP DATABASE xxxx。

DROP DATABASE

Azure SQL Database

You must be connected to the master database to drop a database.

The DROP DATABASE statement must be the only statement in a SQL batch and you can drop only one database at a time.

<小时/>

其次，您应该检查是否有 DELETE LOCK 来防止删除数据库。

Lock resources to prevent unexpected changes