Skip to main content

DELETE DATABASE

Description​

Delete an existing database from a Lake.

Note that the SQL statement does not end with ;

info

By default the operation fails if the database has any dependent tables or capture streams. Use CASCADE to delete dependents in the same call.

Syntax​

DELETE DATABASE `<name>` LAKE = `<lake>` [CASCADE]

Sample response

Examples​

DELETE DATABASE `my_database` LAKE = `my_lake`
DELETE DATABASE `my_database` LAKE = `my_lake` CASCADE

Required parameters​

  • <name>: Name of the database to delete.
  • LAKE: Name of the lake that contains the database.

Optional clauses​

  • CASCADE: Deletes dependent tables and capture streams before the database.