Updated on 2026-05-26 GMT+08:00

Deleting a Database on the DLI Console

You can delete an unused database from the DLI console: when a database is no longer needed, such as after a test database has completed testing; if a database has errors or anomalies that cannot be fixed; when there is a need to reorganize the data structure, such as by modifying table designs; or if a database is idle and has no practical use.

This section describes how to delete a database on the DLI management console.

Precautions

  • Databases or tables that are being used for running jobs cannot be deleted.
  • The administrator, database owner, and users with the database deletion permission can delete the database.

    If a database or table is deleted, it cannot be recovered. Exercise caution when performing this operation.

Deleting a Database

  1. Log in to the DLI management console.
  2. In the navigation pane, choose Data Management > Databases and Tables.
  3. Locate the row where the target database locates and click More > Drop Database in the Operation column.

    You cannot delete databases that contain tables. To delete a database containing tables, delete the tables first.

  4. In the displayed dialog box, click Yes.