---
schema_version: "1"
id: 4e58b8c087aaac320b6d456ea9399749fca8fb9550fc6cecf70e79f19aba5d67
title: DROP DATABASE
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/tableau-sql-commands/drop-database.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/drop-database.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: dd0ad47e96fef57ed9355f579652b6b9751d6195951eea7121a17c64c24a5386
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# DROP DATABASE

**Applies to:** ❌ Data 360 SQL ✅ Tableau Hyper API

Remove a database.

## Syntax

```sql
DROP 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.