MS SQL Server Concepts and Programming Question: Download Questions PDF
How to delete a database in MS SQL Server?
Answer:
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 YourDataBaseName
GO
The database "YourDataBaseName" 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.
DROP DATABASE database_name
For example, execute this statement:
DROP DATABASE YourDataBaseName
GO
The database "YourDataBaseName" 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.
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
How to set the current database in MS SQL Server? | Why I am getting this error when dropping a database in MS SQL Server? |