"DROP DATABASE" - Deleting Databases in SQL Server


How to delete a database in SQL Server?

✍: FYIcenter.com


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:


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.


Database in Use When Dropping a Database in SQL Server

"USE" - Setting the Current Database in SQL Server

Managing Databases and Physical Files in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-11-24, 1446🔥, 0💬