- Stop the sql server within services
- Delete the physical files (.mdf , .ldf)
- Start the sql server
- Right click the offline database and click delete
USE MASTER
GO
ALTER DATABASE Ken_Database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DROP DATABASE Ken_Database
GO