DROP DATABASE

Applies to: ❌ Data 360 SQL ✅ Tableau Hyper API

Remove a database.

Syntax 

 
1DROP DATABASE [IF EXISTS] <name>

Description 

DROP DATABASE drops a database. It deletes the underlying file containing the data, as well as any associated files such as the transaction log. It cannot be executed while you or anyone else is connected to the target database.

DROP DATABASE cannot be undone. Use it with care!

Parameters 
IF EXISTS

Do not throw an error if the database does not exist.

<name>

The name of the database to remove.

Compatibility 

There is no DROP DATABASE statement in the SQL standard.

Data 360 REST API Reference
Data 360 SQL Reference
Data 360 SQL and Tableau Hyper API
Data 360 SQL Syntax
Data Types
Scalar Functions
Aggregate Functions
Window Functions
Set Returning Functions
SQL Commands for Tableau Hyper API
External File Support
INSERT
UPDATE
DELETE
TRUNCATE
COPY FROM
COPY TO
CREATE DATABASE
CREATE SCHEMA
CREATE TABLE
CREATE TABLE AS
CREATE EXTERNAL TABLE
ALTER SCHEMA
ALTER TABLE
DROP TABLE
DROP SCHEMA
DROP DATABASE
EXPLAIN
PREPARE
EXECUTE
DEALLOCATE

DID THIS ARTICLE SOLVE YOUR ISSUE?
Let us know so we can improve!