User Tools

Site Tools

A PCRE internal error occured. This might be caused by a faulty plugin


**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]


====== DROP DATABASE Statement ====== DROP DATABASE statement allows you to drop a database. **Syntax**: <code language=sql> DROP DATABASE | SCHEMA [IF EXISTS] dbname_expr </code> **Example**: Drop a database named //testYYYYMMDD// (current date): <code language=sql> drop database if exists 'test' || replace(current_date, '-', ''); </code> **Compatibility:** Hive **Version:** HPL/SQL 0.3.17 See also: * [[create-database|CREATE DATABASE]] * [[use|USE]]