SQL BASICS – How to Delete a Database

Press CTRL+N to open the new query window.

Type into the new Query window.

USE Master
DROP DATABASE KBTECHPRO

If you get an error it’s because there are opened connections.

run the following
 

ALTER DATABASE [KBTECHPRO] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE [KBTECHPRO] SET MULTI_USER;

What this does:

• SINGLE_USER mode closes all active connections and allows only one user to connect.
• WITH ROLLBACK IMMEDIATE rolls back any incomplete transactions and immediately disconnects users.
• MULTI_USER mode puts the database back to allowing multiple users to connect.
   

Then run

DROP DATABASE [KBTECHPRO]