Help Center > > User Guide> MRS Cluster Component Operation Guide> Using CarbonData> Deleting a CarbonData Table

Deleting a CarbonData Table

Updated at: Sep 12, 2019 GMT+08:00

Scenario

Unused CarbonData tables can be deleted. After a CarbonData table is deleted, its metadata and loaded data are deleted together.

Procedure

  1. Run the following command to delete a CarbonData table.

    DROP TABLE [IF EXISTS] [db_name.]table_name;

    db_name is optional. If db_name is not specified, the table named table_name in the current database is deleted.

    For example, run the following command to delete the productSalesTable table in the productdb database:

    DROP TABLE productdb.productSalesTable;

  2. Run the following command to check whether the table is deleted.

    SHOW TABLES;

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel