Deleting a Database or a Table

Updated on 2022-07-04 GMT+08:00

View PDF

You can delete unnecessary databases and tables based on actual conditions.

You are not allowed to delete databases or tables that are being used for running jobs.
The administrator, database owner, and users with the database deletion permission can delete the database. The administrator, database owner, and users with the table deletion permission can delete the table.
NOTE:

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

You can delete a table on either the Data Management page or the SQL Editor page.

Delete the table on the Data Management page.
1. On the left of the management console, choose Data Management > Databases and Tables.
2. Locate the row where the database whose tables you want to delete, click the database name to switch to the Table Management page.
3. Locate the row where the target table resides and click More > Drop in the Operation column.
4. In the dialog box that is displayed, click OK.
Delete a table on the SQL Editor page.
1. On the top menu bar of the DLI management console, click SQL Editor.
2. In the navigation tree on the left, click Databases. Click the name of the database whose table is to be deleted. The tables in the selected database are displayed.
3. Click on the right of the table and choose Drop Table from the shortcut menu.
4. In the dialog box that is displayed, click OK.

On the left of the management console, choose Data Management > Databases and Tables.
Locate the row where the target database resides and click More > Drop Database in the Operation column.
NOTE:

You cannot delete databases that contain tables. To delete a database containing tables, delete the tables first.
In the dialog box that is displayed, click OK.