Answers for "sql drop database if exists"

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

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

sql drop database if exists

DROP DATABASE IF EXISTS TestDb;
Code language: SQL (Structured Query Language) (sql)

Posted by: Guest on September-13-2021

Code answers related to "sql drop database if exists"