how remove use of database sql code example
Example 1: how to drop a database in sql server when it is in use
BY LOVE SINGH
USE master;
GO
ALTER DATABASE OnlineRestaurant2
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
DROP DATABASE OnlineRestaurant2;
Example 2: remove from database
DELETE FROM table_name WHERE condition;