Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hudi/ Hudi SQL Syntax Reference/ Hudi DDL Syntax/ DROP TABLE
Updated on 2024-10-09 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 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.

Examples

DROP TABLE IF EXISTS hudidb.h1;

System Response

The table will be deleted.

Parent topic: Hudi DDL Syntax