Introduction

In this tutorial, we want to delete an existing database by using a SQL Statement. In order to do this, we use the DROP DATABASE Statement.

We have already created a server called DLNerdsServer and a database called dlnerdsacademy.

Now, we want to delete the database dlnerdsacademy.

SQL Statement

First, we need to disconnect with the database that should be deleted. Therefore we disconnect with the database dlnerdsacademy.

Then we navigate to the default database, open the Query Tool and execute the following SQL statement:

DROP DATABASE dlnerdsacademy;

Deleted Database

Now, we can see that the database dlnerdsacademy is no longer listed under the server. It has been successfully deleted.

Conclusion

Congratulations! Now you are one step closer to become an AI Expert. You have seen that it is very easy to deleate a database with the DROP DATABASE Statement. Try it yourself!

Instagram

Also check out our Instagram page. We appreciate your like or comment. Feel free to share this post with your friends.