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, 1372🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...