DROPPING A DATABASE

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

SYNTAX 

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.

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

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin