Ultimate access to all questions.
Why does dropping a Delta table only delete the table's metadata, leaving the data files intact in storage?
Explanation:
External (unmanaged) tables store data in an external storage path specified by a LOCATION
clause. Dropping such a table only removes its metadata, not the underlying data files. Reference: Databricks Documentation on Unmanaged Tables