Sidebar

HPL/SQL is included to Apache Hive since version 2.0

drop-database

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

Version: HPL/SQL 0.3.17

See also: