You need to open the table exclusively and ZAP it.
Another approach is to overwrite the existing table with the new one, like:
set safety off
if used(table_name)
use in (table_name)
endif
select * from ... into (table_name)

Details may depend on whether this is a free table or part of database.

>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.