Help Center/ Data Lake Insight/ Delta SQL Syntax Reference/ Delta SQL Syntax Reference/ Delta DDL Syntax/ DROP TABLE
Updated on 2025-04-21 GMT+08:00
View PDF

DROP TABLE

Function

This command deletes an existing table.

Syntax

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

Parameter Description

Table 1 Parameter descriptions of DROP TABLE

Parameter

Description

db_name

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

table_name

Name of the table to be deleted.

Required Permissions

  • SQL permissions
    Table 2 Permissions required for executing DROP TABLE

    Permission Description

    DROP_TABLE permission on the database where the table is
  • Fine-grained permission: dli:table:dropTable
  • Metadata services provided by LakeFormation. Refer to the LakeFormation documentation for details on permission configuration.

Examples

DROP TABLE IF EXISTS db0.delta_table0;

System Response

The table is successfully deleted from the metadata and cannot be found using show and describe.

Parent topic: Delta DDL Syntax