vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/mrs/component-operation-guide/mrs_01_0389.html
Yang, Tong 6182f91ba8 MRS component operation guide_normal 2.0.38.SP20 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>
2022-12-09 14:55:21 +00:00

2.4 KiB
Raw Permalink Blame History

Deleting a CarbonData Table

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 confirm that the table is deleted:

    SHOW TABLES;