Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Permanently Deleting Records using SQL
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement