Help Center/ Data Lake Insight/ User Guide/ Creating Databases and Tables/ Managing Table Resources on the DLI Console/ Deleting a Table on the DLI Console
Updated on 2024-09-30 GMT+08:00
View PDF
Share

Deleting a Table on the DLI Console

You can delete tables as needed.

Precautions

  • Databases or tables that are being used for running jobs cannot be deleted.
  • Only administrators, table owners, and users with table deletion permission can delete tables.

    Deleted data tables cannot be restored. Exercise caution when performing this operation.

Deleting a Table

You can delete a table on either the Data Management page or the SQL Editor page.
  • On the Data Management page
    1. In the navigation pane on the left of the console, choose Data Management > Databases and Tables.
    2. Locate the database whose tables you want to delete and click its name.
    3. On the displayed page, select the table to delete, click More in the Operation column, and select Drop Table.
    4. In the displayed dialog box, click Yes.
  • On the SQL Editor page
    1. In the navigation pane on the left of the console, choose SQL Editor.
    2. In the middle pane, click the Databases tab. Click the name of the database whose tables you want to delete.
    3. Click next to the table to delete and select Delete.
    4. In the displayed Drop Table dialog box, click Yes.