how to drop a database in sql server when it is in use
snippet in sql

how to delete a database in sql

user9062

DROP DATABASE databasename; 

how to drop a database in sql server when it is in use

user7124

BY LOVE SINGH

USE master;
GO
ALTER DATABASE OnlineRestaurant2 
SET SINGLE_USER 
WITH ROLLBACK IMMEDIATE;
GO
DROP DATABASE OnlineRestaurant2;