drop database sql query 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: Sql query to force the database to be drop
BY LOVE SINGH
USE master;
GO
ALTER DATABASE OnlineRestaurant2
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
DROP DATABASE OnlineRestaurant2;