Permanent delete attachments

Hi support team,

If we are to remove all existing attachments, is it safe to remove them by going directly into Attachment database table and running SQL DELETE statement?


Hi Christanto. Yes, you’re correct, deleting the contents of that table will remove all attachments from the database. This is not recoverable, so if you’re not sure if you need them make a backup of your database. The following can be run in SQL Server Management Studio with the AsiRentalManager database selected.

– Delete everything from attachment table, not recoverable
DELETE FROM Attachment;