Collections:
"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:
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
2016-11-24, 1382🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...