"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.

 

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, 1340🔥, 0💬