Inn Dynamics 365 Business Central online, I see every day partners and customers with huge tables that must be deleted (sometimes with data size > 50 GB and with > 60 millions of records).

Deleting such huge tables seems not possible on SaaS (the process takes ages and often fails) and to do a cleanup a support request to MS must be raised (and sometimes it's also not satisfied).

Why not providing a native way to perform a TRUNCATE TABLE operation? Maybe with limitations if you think that SIFT can be a problem (tables that often need a truncate have no SIFT, at least on my experience and on all problematic cases I saw in the last years).

Please think on that... it's a must on SaaS now, expecially after years of usage of a SaaS tenant.

P.S. yes there are retention policies, but they are often forgotted or activated too late.

More details here:

https://demiliani.com/2025/03/25/dynamics-365-business-central-the-problem-of-large-data-deletion/