DROP EXTERNAL ICEBERG TABLE

Note

This command does not drop the specified Apache Iceberg table or its data; it simply stops the optimization process. Dropping an external tables means the table will no longer be managed by Upsolver.

Syntax

DROP EXTERNAL TABLE [ IF EXISTS ] <table_identifier>;    

IF EXISTS

(Optional) To prevent the Upsolver query engine from returning an error if the table does not exist, include IF EXISTS in your DROP statement; instead, you will see the message Operation resulted in no change.

Example

DROP EXTERNAL TABLE IF EXISTS "my_test_table";