Skip to main content

DROP TABLE

Removes a table from your data source.

When dropping an Apache Iceberg table:

  • For external Nessie data sources, the DROP TABLE command logically removes a table from the source. Even though the table is removed from the catalog, it still physically exists in storage until garbage collection removes it.
  • For Amazon S3 data sources, the DROP TABLE command logically removes a table from the source and physically removes all files associated with the table. After the table is dropped, it is permanently deleted and cannot be restored.
  • For AWS Glue data sources, the DROP TABLE command removes a table from the catalog. The datafiles are not deleted from the warehouse.
Syntax
DROP TABLE <table_name>

Parameters​

{{< sql-section file="data/sql/arctic-tables.json" data="droppingATable" >}}

Example​

Drop table
DROP TABLE demo.example_table