Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using HetuEngine/ Common HetuEngine SQL Syntax/ HetuEngine DDL SQL Syntax/ DROP TABLE
Updated on 2024-12-13 GMT+08:00
View PDF
Share

DROP TABLE

Syntax

DROP TABLE [ IF EXISTS ] table_name

Description

This statement is used to drop an existing table.

If the optional parameter IF EXISTS is specified and the table to be deleted does not exist, no error is reported.

The deleted data rows are moved to the recycle bin of HDFS.

Example

create table testfordrop(name varchar);
drop table if exists testfordrop;