DROPPING A DATABASE

For dropping a SQL Database, we can use the “DROP DATABASE “statement.

SYNTAX 

10.png

Where,

  • CREATE DATABASE: KEYWORD used to drop a database

  • DATABASENAME: The Name of the Database that you want to drop.

 

Example

Let’s drop a Demo Database say TestDb which we initially created in the previous chapter.

11.png

Figure 4.1. DROP Database

 

Note: A Database consists of a collection of huge volumes of data, so make sure that you have proper Admin access before dropping a Database. A dropped Database cannot be recreated and it may lead to loss of all the stored data.

PRACTICE YOURSELF

12.png