Hive Drop Database

Hive Drop database is used to drop the database from the meta store, It will drop the database and all of its table content, before dropping the database we have to ensure that all the tables under that particular database have been dropped or not by manually dropping each table or by using cascade option.

How to Drop the Database?

Example:
if we want to drop all the tables inside this studentdb database, we have use the query like something below.
Be cautious before you use this drop command in Production environment with Table or Database, you may tend to loose the data.