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, 1458🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...