drop temp table is not deleting the actual table data -- need to enable purge

[hpasumarthi]

hello Team
We have realised that dropping the temp table in not enough to remove actual data, we need to enable purge.

Can we enable the property while creating the table or enable it before dropping it.

Option 1: CTAS should include table property 'external.table.purge'='true'
or
Option 2: enable it before deleting the table.

ALTER TABLE table_name SET TBLPROPERTIES('external.table.purge'='true');
DROP TABLE IF EXISTS table_name;

This fix should be applicable for External and iceberg tables.