After the metadata.json file of the Iceberg table was accidentally deleted, the drop table failed. How can I delete this table from the metadata?

[SGITLOGIN]

Query engine

Iceberg 1.6.1

Spark 3.4.2

Spark configuration：

spark.sql.catalog.spark_catalog = org.apache.iceberg.spark.SparkSessionCatalog
spark.sql.catalog.spark_catalog.type = hive
spark.sql.extensions=org.apache.iceberg.spark.extensions.IcebergSparkSessionExtensions

Question

After the metadata.json file is accidentally deleted, drop table fails and a NotFoundException is reported. How should I delete the table from the metadata?

[Fokko]

Thanks for reporting this @SGITLOGIN. I'm going to close this one as it is a duplicate of #12062.