How do I drop or delete a database?

Question

Using the SQL Server DROP DATABASE statement to delete a database. To remove an existing database from a SQL Server instance, you use the DROP DATABASE statement. In this syntax, you specify the name of the database that you want to drop after the DROP DATABASE keywords.

How do I completely delete a database?

To delete a database1In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.2Expand Databases, right-click the database to delete, and then click Delete.3Confirm the correct database is selected, and then click OK.Delete a Database - SQL Server | Microsoft Docs

How can I DROP database?

You cannot drop a database currently being used. This means locks being held for reading or writing by any user. One way to remove users from the database is to use ALTER DATABASE to set the database to SINGLE_USER.

Which command is used to DROP database?

Syntax: DROP DATABASE database_name; database_name: Name of the database to be deleted.

Expert · Answer