How to delete the database in MS SQL Server
To delete the database in MS SQL Server, we use the DROP command.
To delete the database in MS SQL Server, we use the DROP command . Here are 2 ways to use this command.
Method 1: Use T-SQL Script
Here is the syntax to delete the database in MS SQL Server.
Drop database
For example, to delete a CSLD named Testdb, you run the query
Drop database Testdb
Method 2: Use MS SQL Server Management Studio
Connect to SQL Server and right click on the database you want to delete. Select delete and the following screen will appear.
Confirm the information to delete the selected database
Select OK to delete the selected database ( Testdb in this example ) from MS SQL Server.
Previous article: How to select a database in MS SQL Server
Next lesson: How to create a copy of data in MS SQL Server
Update 25 May 2019
You should read it
- DROP USER command in SQL Server
- DROP TABLE command in SQL Server
- DROP LOGIN command in SQL Server
- DELETE TOP command in SQL Server
- DELETE command in SQL Server
- SEQUENCE in SQL Server
- VIEW in SQL Server
- How to create a database in MS SQL Server
- How to start and stop services in MS SQL Server
- The difference between web server and app server
- FUNCTION (Function) in SQL Server
- How to decentralize users in MS SQL Server