Information générale
Catégorie:
Codage, syntaxe et commandes
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.
Précédent
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