How to drop DB in Synapse, since code from your "documentation" is not working?

Question

What is the proper way to drop a DB in Azure Synapse?

Code from this documentation produces an error "SINGLE_USER is not supported for ALTER DATABASE".

Answer 1

Kill all active sessions before trying to drop the database.

Please try the following steps.

First, run the following script on the master database.

    SELECT DB_NAME(database_id) AS DatabaseName, 'kill '+cast(session_id as varchar(10)), *
    FROM sys.dm_exec_sessions
    WHERE DB_NAME(database_id) NOT IN ('master')
    ORDER BY DatabaseName

Second kill all sessions actively using the database with the output of the previous T-SQL script.

Finally, try to drop the database from Synapse Studio.