Cannot drop a database in Azure Data Studio, because it's currently in use
Someone else is connected, so you need to set it to SINGLE_USER. This will terminate any existing connections, so that the database can be dropped.
USE master;GOALTER DATABASE zap SET SINGLE_USER WITH ROLLBACK IMMEDIATE;GODROP DATABASE zap;GO
You can try the following:
use master;goALTER DATABASE zap SET SINGLE_USER WITH ROLLBACK IMMEDIATE;Gothen drop database.
There is no need to find session which is connected to your database. it can be as simple as an object explorer open in another window. kill the session with the command above and then drop the database.