Apache Hive : HPL/SQL - DROP DATABASE Statement

DROP DATABASE statement allows you to drop a database.

Syntax:

DROP DATABASE | SCHEMA [IF EXISTS] dbname_expr

Example:

Drop a database named testYYYYMMDD (current date):

drop database if exists 'test' || replace(current_date, '-', '');

Compatibility: Hive

See also:

• CREATE DATABASE
• USE