delete 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: sql delete dastabase

Deletes the entire database.
Example: Deletes a database named ‘websitesetup’.
DROP DATABASE websitesetup;