Use TSQL To Drop Database in SQL Server:
At this point you can hit Script button in above window to generate script so you can use anytime you like. Once you hit Script and open in new window. Below Script will be create.
USE [master] GO ALTER DATABASE [TechBrothersIT] SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO USE [master] GO DROP DATABASE [TechBrothersIT] GO
The first part of script will set the database to Single User mode and rollback any open transactions immediately. Second Part of script will drop the database.