Here we will learn how to delete or drop database in sql server using query or direct from sql server management studio.
To drop or delete SQL database we have two different methods one is using Query with “DROP DATABASE” and another one is directly using SQL Server Management Studio
By using “DROP Database” statement we can drop or delete SQL database. Generally to drop database in SQL our syntax will be like as shown below
Following statement is the syntax to drop or delete sql database
DROP DATABASE databasename
Here databasename is the name of database to drop or delete from SQL Server
The following SQL statements will drop or delete database “sqltutorialexamples”
DROP DATABASE sqltutorialexamples
Refresh your database section and check whether your database deleted from your list or not
To delete database from SQL Server open SQL Server Management Studio --> Select your database in Databases section --> Right click and select DELETE Option like as shown below
Whenever we click on Delete Option it will open Delete Modal object window in that click OK to drop or delete database like as shown below
Once process finished refresh your databases section and check whether your database deleted or not.