Another solution is to simply overwrite the old table with a new iteration with the same name.

Use in ( Old Table )

Select ( field list ) from ( table and join code ) into Table ( Old Table's name )



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