We use Coldfusion with a vfp datasource and run a query that deletes all records in a vfp table:
delete * from vfptable

However, as would be expected, it marks all records for deletion, rather than physically deleting them.

How would we pack the table as part of the query? Would it be a stored procedure? If so what might that look like and where would it be placed?

Thanks in advance.