ContextQMD
Back to Starrocks

DROP DATABASE

docs/en/sql-reference/sql-statements/Database/DROP_DATABASE.md

4.1.01.2 KB
Original Source

DROP DATABASE

DROP DATABASE is used to delete a database in StarRocks.

NOTE

This operation requires the DROP privilege on the destination database.

Syntax

sql
DROP DATABASE [IF EXISTS] <db_name> [FORCE]

Take note of the following points:

  • After executing DROP DATABASE to drop a database, you can restore the dropped database by using the RECOVER statement within a specified retention period (the default retention period spans one day), but the pipes (supported from v3.2 onwards) that have been dropped along with the database cannot be recovered.
  • If you execute DROP DATABASE FORCE to drop a database, the database is deleted directly without any checks on whether there are unfinished activities in it and cannot be recovered. Generally, this operation is not recommended.
  • If you drop a database, all pipes (supported from v3.2 onwards) that belong to the database are dropped along with the database.

Examples

  1. Drop database db_text.

    sql
    DROP DATABASE db_test;

References