MS SQL Server Concepts and Programming Question:

How to delete a database in MS SQL Server?

MS SQL Server Interview Question
MS SQL Server Interview Question

Answer:

If you created a database incorrectly, or you have a database that is not needed any more, you can delete it with the "DROP DATABASE" statement with this syntax:

DROP DATABASE database_name

For example, execute this statement:

DROP DATABASE YourDataBaseName
GO

The database "YourDataBaseName" created in the previous tutorial should be deleted from the SQL server.

Warning, if you delete a database, all tables and their data in that database will be deleted.


Previous QuestionNext Question
How to set the current database in MS SQL Server?Why I am getting this error when dropping a database in MS SQL Server?