MsSQL Server: How can I drop DB using T-SQL?

MsSQL Server: How can I drop DB using T-SQL? 8 Nov 2019

No specific Bitcoin Bounty has been announced by author. Still, anyone could send Bitcoin Tips to those who provide a good answer.

I want to drop my DB and close all connections before it

When I try to do it I receive this message:

Cannot drop database "DBName" because it is currently in use.

Thanks..

Tags: sql-server, ubuntu, tsql

Edited Nov 08'19 at 16:28

lampego1@qrid

Created Nov 08'19 at 16:28

lampego1@qrid

ADD COMMENT | SEND TIPS

Internet users could send Bitcoin Tips to you if they like your answer!

Close all active connections:

ALTER DATABASE <DBName> set single_user with rollback immediate
Drop your database:

DROP DATABASE <DBName>

;)

Edited Nov 08'19 at 16:31

root

Created Nov 08'19 at 16:30

root

ADD COMMENT

FavScripts.com is a free tool to save your favorite scripts and commands, then quickly find and copy-paste your commands with just few clicks.

Boost your productivity with FavScripts.com!