Updated on 2025-09-18 GMT+08:00

DROP TABLE

Function

DROP TABLE is a DataArts Fabric SQL syntax used to delete a table with a specified name from LakeFormation.

Precautions

When a managed table is deleted, the metadata, statistics, and data of the table are also deleted. If the data volume is large, the statement execution may take a long time. When an external table is deleted, only the metadata and statistics of the table are deleted, but the data is not deleted.

Syntax

1
DROP TABLE [IF EXISTS] table_name;

Parameter Description

  • IF EXISTS

    Reports a notice instead of an error if the specified table does not exist.

  • table_name

    Name of the LakeFormation table.

Examples

Delete the test_table table.

1
DROP TABLE test_table;