Answers for "drop db sql server"

SQL
4

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;
Posted by: Guest on June-25-2020
0

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;
Posted by: Guest on May-07-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language