"DROP DATABASE" - Deleting Databases in SQL Server

Q

How to delete a database in SQL Server?

✍: FYIcenter.com

A

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 FyiCenterData
GO

The database "FyiCenterData" 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.

 

Managing Databases and Physical Files in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-24, 689👍, 0💬