Help Center/ MapReduce Service/ Component Operation Guide (ME-Abu Dhabi Region)/ Using CarbonData (for MRS 3.x or Later)/ CarbonData Syntax Reference/ DDL/ DROP TABLE
Updated on 2022-02-22 GMT+08:00
View PDF
Share

DROP TABLE

Function

This command is used to delete an existing table.

Syntax

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

Parameter Description

Table 1 DROP TABLE parameters

Parameter

Description

db_name

Database name. If this parameter is not specified, the current database is selected.

table_name

Name of the table to be deleted

Precautions

In this command, IF EXISTS and db_name are optional.

Example

DROP TABLE IF EXISTS productDatabase.productSalesTable;

System Response

The table will be deleted.

Parent topic: DDL